
|
If you were logged in you would be able to see more operations.
|
Google issue summary
|
|
|
Zend Framework
Created: 08/Jun/08 10:32 PM
Updated: 08/Jun/08 10:39 PM
|
|
| Component/s: |
Zend_Gdata
|
| Affects Version/s: |
None
|
| Fix Version/s: |
None
|
|
|
Please add better helper functions to iterate over spreadsheets data.
|
|
Description
|
Please add better helper functions to iterate over spreadsheets data. |
Show » |
|
<?php require_once 'Zend/Loader.php'; Zend_Loader::loadClass('Zend_Http_Client'); Zend_Loader::loadClass('Zend_Gdata'); Zend_Loader::loadClass('Zend_Gdata_ClientLogin'); Zend_Loader::loadClass('Zend_Gdata_Spreadsheets'); $user = 'USERNAME'; $pass = 'PASSWORD'; $authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME; $httpClient = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $authService); $gdClient = new Zend_Gdata_Spreadsheets($httpClient); $spreadsheets = $gdClient->getSpreadsheetFeed(); foreach($spreadsheets as $spreadsheet) { foreach($spreadsheet->getWorksheets() as $worksheet) { // array of associative arrays-- indexed on cell name (A1,B2) // child array includes forumu print_r($worksheet->getContentsAsCells()); // also valid - print_r($worksheet->getContentsAsCells('A1:B3')); // also valid returns empty cells - print_r($worksheet->getContentsAsCells('A1:B3', true)); // array of associative arrays-- indexed on column names print_r($worksheet->getContentsAsRows()); } }