Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Zend_Gdata
-
Labels:None
Description
Please add better helper functions to iterate over spreadsheets data.
Added code in r9641 to allow for iterating over spreadsheets and worksheets.
<?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()); } }<?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()); } }