History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: ZF-3416
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Ryan Boyd
Reporter: Ryan Boyd
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Google issue summary
Zend Framework

Helper functions needed for Spreadsheets-- iterate over spreadsheets data

Created: 08/Jun/08 10:32 PM   Updated: 26/Feb/09 04:59 PM
Component/s: Zend_Gdata
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

Tags:
Participants: Ryan Boyd and Trevor Johns


 Description  « Hide
Please add better helper functions to iterate over spreadsheets data.

 All   Comments   Work Log   Change History   FishEye   Crucible      Sort Order: Ascending order - Click to sort in descending order
Ryan Boyd - 08/Jun/08 10:39 PM
Added code in r9641 to allow for iterating over spreadsheets and worksheets.
Example usage
<?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());
    }
}

Trevor Johns - 26/Feb/09 04:59 PM
Ryan,
Can we close this as fixed?