通过php从Google Spreadsheet打印随机行

Question

I would like to create a PHP script that fetches a few rows from a Google Spreadsheets and display it in html.

$authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;
$httpClient = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $authService);
$gdClient = new Zend_Gdata_Spreadsheets($httpClient);
$feed = $gdClient->getSpreadsheetFeed('https://spreadsheets.google.com/ccc?key=MY_DOC_KEY');
$currKey = explode('/', $feed->entries[0]->id->text);
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($this->currKey);
$query->setWorksheetId($this->currWkshtId);
$query->setMinCol(1);
$query->setMaxCol(7);
$query->setMinRow(2);
$feed = $gdClient->getCellFeed($query);

However that throws a really ugly error message. What am i doing wrong?

Fatal error: Uncaught exception 'Zend_Gdata_App_Exception' with message 'DOMDocument cannot parse XML: DOMDocument::loadXML() Extra content at the end of the document in Entity, line: 23'

Answer 1

Short answer:

Why do you want to list the spreadsheets if you already know which spreadsheet you want to read from?

Long answer:

I am new to both Zend and Gdata, but tried to run your code and got the same exception. But after reading the docs (http://framework.zend.com/manual/en/zend.gdata.spreadsheets.html) I've tried replacing:

$feed = $gdClient->getSpreadsheetFeed('https://spreadsheets.google.com/ccc?key=MY_DOC_KEY');

with:

$feed = $gdClient->getSpreadsheetFeed();

and after adding the obvious:

foreach($feed as $cellEntry) {
  $row = $cellEntry->cell->getRow();
  $col = $cellEntry->cell->getColumn();  
  $val = $cellEntry->cell->getText();    
  echo "$row, $col = $val
";      
}        

I got some data.

Then I understood, these two lines are not needed at all:

$feed = $gdClient->getSpreadsheetFeed('https://spreadsheets.google.com/ccc?key=MY_DOC_KEY');
$currKey = explode('/', $feed->entries[0]->id->text);

So getSpreadsheetFeed is useful if you want to list/filter spreadsheets (and then there's no point in suplying the key) and to read the data from the known spreadsheet it's enough to use just the Zend_Gdata_Spreadsheets_CellQuery.

Now I learned something.