Zend GData Spreadsheet WorksheetID

Question

What is the $worksheetId from the Zend GData documentation supposed to be?

http://framework.zend.com/manual/en/zend.gdata.spreadsheets.html

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

The documentation uses that $worksheetId several times, but I can't seem to see where to get that from a spreadsheet.

score 2 · Accepted Answer · answered Aug 29 '11 at 02:43

2

If you don't know the worksheet identifiers, you have to perform a first query to retrieve the worksheets metafeed for your spreadsheet:

$query = new Zend_Gdata_Spreadsheets_DocumentQuery();
$query->setSpreadsheetKey($spreadsheetKey);
$feed = $spreadsheetService->getWorksheetFeed($query);

Then, you iterate $feed->entries and each entry will represent a worksheet and have an identifier.

answered Aug 29 '11 at 02:43

Claudio Cherubino

14,896
1
35
42

Mostly what I was looking for. I wish Zend's API docs were a bit better... or am I missing something? – David Souther Aug 31 '11 at 04:50

score 0 · Answer 2 · edited May 23 '17 at 12:21

0

The $worksheetId is the worksheet identifier. Worksheets have a gid identifier (1,2,....) that you can see directly in the url of the document when is opened.

Unfortunately you can't access to them through API with that id.

Use instead the codes that you find in the following discussion:

Worksheet GIDs

edited May 23 '17 at 12:21

Community

1
1

answered Dec 14 '12 at 15:45

Giu87

96
5

Zend GData Spreadsheet WorksheetID

2 Answers2