阅读 Google 文档电子表格

发布于 2024-09-15 03:25:07 字数 197 浏览 5 评论 0原文

是否可以使用 PHP 从 Google Docs 电子表格中提取行？

在 SQL 中我会使用类似的内容：

SELECT * FROM table WHERE field = 'value' LIMIT 1

有办法做到这一点吗？我听说你应该使用“Zend”框架，但我也无法弄清楚。任何帮助将不胜感激

原文

Is it possible to pull rows from a Google Docs spreadsheet using PHP?

In SQL I would use something like:

SELECT * FROM table WHERE field = 'value' LIMIT 1

Is there a way to do this? I've heard you are supposed to use a 'Zend' framework, but I haven't been able to figure that out either. Any help would be appreciated

分享到QQ

分享到微博

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

发布评论

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

萌面超妹 2024-09-22 03:25:07

来自 Zend_Gdata文档：

<?php
  $query = new Zend_Gdata_Spreadsheets_ListQuery();
  $query->setSpreadsheetKey($spreadsheetKey);
  $query->setWorksheetId($worksheetId);
  $query->setSpreadsheetQuery('name=John and age>25');
  $listFeed = $spreadsheetService->getListFeed($query);
?>

并设置$spreadsheetService 对象：

<?php
  $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
  $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
  $spreadsheetService = new Zend_Gdata_Spreadsheets($client);
  $feed = $spreadsheetService->getSpreadsheetFeed();
?>

您需要下载完整的 Zend Framework 或独立的 Google 数据库。

From the Zend_Gdata documentation:

<?php
  $query = new Zend_Gdata_Spreadsheets_ListQuery();
  $query->setSpreadsheetKey($spreadsheetKey);
  $query->setWorksheetId($worksheetId);
  $query->setSpreadsheetQuery('name=John and age>25');
  $listFeed = $spreadsheetService->getListFeed($query);
?>

And to setup the $spreadsheetService object:

<?php
  $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
  $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service);
  $spreadsheetService = new Zend_Gdata_Spreadsheets($client);
  $feed = $spreadsheetService->getSpreadsheetFeed();
?>

You'll need to download either the full Zend Framework, or the standalone Google Data library.

回复收藏 0 原文