当前位置：文江博客话题详情

使用 Zend 将工作表添加到 PHP 中的 Google 电子表格

发布于 2024-12-25 02:53:34 字数 51 浏览 3 评论 0原文

如何使用 Zend 将工作表添加到 Google 文档电子表格？

谢谢！

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

于我来说 2025-01-01 02:53:34

这个不太容易弄清楚，这是对我有用的代码（感谢这个文章和Zend Framework 快速参考）

// Connection & spreadsheet API
$client = Zend_Gdata_ClientLogin::getHttpClient('[email protected]', 'sunshine-', Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME);
$service = new Zend_Gdata_Spreadsheets($client);

// Get worksheet feed
$query = new Zend_Gdata_Spreadsheets_DocumentQuery();
$query->setSpreadsheetKey('your spreadsheet key');
$feed = $service->getWorksheetFeed($query);

// Create new worksheet structure
$newWorksheet = new Zend_Gdata_Spreadsheets_WorksheetEntry();
$newWorksheet->setTitle(new Zend_Gdata_App_Extension_Title("My Brillant New Worsheet", null));
$newWorksheet->setRowCount(new Zend_Gdata_Spreadsheets_Extension_RowCount(10));
$newWorksheet->setColumnCount(new Zend_Gdata_Spreadsheets_Extension_ColCount(10));

// Add new worksheet to worksheets feed
$service->insertEntry($newWorksheet->saveXML(), $feed->getLink('self')->getHref());

This one is not very easy to figure out, here is the code that worked for me (thanks to this article and Zend Framework Quick Reference)

// Connection & spreadsheet API
$client = Zend_Gdata_ClientLogin::getHttpClient('[email protected]', 'sunshine-', Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME);
$service = new Zend_Gdata_Spreadsheets($client);

// Get worksheet feed
$query = new Zend_Gdata_Spreadsheets_DocumentQuery();
$query->setSpreadsheetKey('your spreadsheet key');
$feed = $service->getWorksheetFeed($query);

// Create new worksheet structure
$newWorksheet = new Zend_Gdata_Spreadsheets_WorksheetEntry();
$newWorksheet->setTitle(new Zend_Gdata_App_Extension_Title("My Brillant New Worsheet", null));
$newWorksheet->setRowCount(new Zend_Gdata_Spreadsheets_Extension_RowCount(10));
$newWorksheet->setColumnCount(new Zend_Gdata_Spreadsheets_Extension_ColCount(10));

// Add new worksheet to worksheets feed
$service->insertEntry($newWorksheet->saveXML(), $feed->getLink('self')->getHref());

回复收藏 0 原文

~没有更多了~