zend framework - Google Spreadsheets Get Cell Comments/Notes -

i'm having nasty time learning how use gdata api , zend framework.

i've got spreadsheet want data from.

i've managed array i'm happy using following code (most on bloated)

<?php /* load zend gdata classes. */ function number_ending($number){    $suff = array("","st","nd","rd","th");    $index = intval($number);    if($index > 4){      $index = 4;    }elseif($index < 1){      $index = 0;    }    return ($number . $suff[$index]);  }   require_once 'zend/loader.php'; zend_loader::loadclass('zend_gdata_authsub'); zend_loader::loadclass('zend_gdata_gbase'); zend_loader::loadclass('zend_gdata_spreadsheets'); zend_loader::loadclass('zend_gdata_clientlogin');  $username = "xxxxxxxxxxxxxxx"; $password = "xxxxxxxxx"; $key = "xxxxxxxxxxxx";  //--------------------------------------------------------------------------------- // init zend gdata service  $service = zend_gdata_spreadsheets::auth_service_name; $client = zend_gdata_clientlogin::gethttpclient($username, $password, $service); $spreadsheetservice = new zend_gdata_spreadsheets($client);  //-------------------------------------------------------------------------------- // example 1: cell data  $query = new zend_gdata_spreadsheets_documentquery(); $query->setspreadsheetkey($key); $feed = $spreadsheetservice->getworksheetfeed($query); $entries = $feed->entries[0]->getcontentsasrows();  var_dump($entries); exit;  //sort headings out $headingrow = array_slice($entries[0], 1, 6); $headings = array(); reset($headingrow); $month = key($headingrow); foreach ($headingrow $key => $value) {     $headings[] = number_ending($value); }  //sort content unset($entries[0]); $people = array(); foreach($entries $k => $person){     $person = array_slice($person, 0, 6);     $formatted = array();     foreach ($person $key => $value) {         $formatted[] = $value;     }     $people[$formatted[0]] = $formatted;     array_shift( $people[$formatted[0]] ); }  foreach ($people $pkey => $person) {     foreach ($person $key => $date) {         $people[$pkey][$headings[$key]] = $date;         unset($people[$pkey][$key]);     } } 

however data i'm getting doesn't contain of notes/comments assigned cell.

all i'm getting returned is

array (size=10)   0 =>      array (size=85)       '_cokwr' => string 'column a' (length=11)       'may' => string '29' (length=2)       '_e1qt2' => string '30' (length=2)       '_e35dj' => string '1' (length=1)       '_e4jxw' => string '2' (length=1)       '_e5yid' => string '3' (length=1)       '_faot2' => string '4' (length=1)       'may_2' => string '6' (length=1)       '_yhrze' => string '7' (length=1)       '_yj6jv' => string '8' (length=1)       '_ykl48' => string '9' (length=1)       '_ylzop' => string '10' (length=2)       '_yc5pq' => string '11' (length=2)       'may_3' => string '13' (length=2)       '_ygdf1' => string '14' (length=2)       '_yt0iq' => string '15' (length=2)       '_yuf37' => string '16' (length=2)       '_yvtnk' => string '17' (length=2)       '_yx881' => string '18' (length=2)       'may_4' => string '20' (length=2)       '_yq7dw' => string '21' (length=2)       '_yrlyd' => string '22' (length=2)       '_u4gbe' => string '23' (length=2)       '_u5uvv' => string '24' (length=2)       '_u79g8' => string '25' (length=2)       'may_5' => string '27' (length=2)       '_u08m7' => string '28' (length=2)       '_u1n6k' => string '29' (length=2)       '_u31r1' => string '30' (length=2)       '_ufouq' => string '31' (length=2)       '_uh3f7' => string '1' (length=1)       'june' => string '3' (length=1)       '_ua2l2' => string '4' (length=1)       '_ubh5j' => string '5' (length=1)       '_ucvpw' => string '6' (length=1)       '_ueaad' => string '7' (length=1)       '_uqxe2' => string '8' (length=1)       'june_2' => string '10' (length=2)       '_uv53d' => string '11' (length=2)       '_ulb4e' => string '12' (length=2)       '_umpov' => string '13' (length=2)       '_uo498' => string '14' (length=2)       '_upitp' => string '15' (length=2)       'june_3' => string '17' (length=2)       '_v4z28' => string '18' (length=2)       '_v6dmp' => string '19' (length=2)       '_uwjnq' => string '20' (length=2)       '_uxy87' => string '21' (length=2)       '_uzcsk' => string '22' (length=2)       'june_4' => string '24' (length=2)       '_vet2z' => string '25' (length=2)       '_vg7nc' => string '26' (length=2)       '_vhm7t' => string '27' (length=2)       '_v7s8u' => string '28' (length=2)       '_v96tb' => string '29' (length=2)       'july' => string '1' (length=1)       '_von1u' => string '2' (length=1)       '_vq1mb' => string '3' (length=1)       '_vrg6o' => string '4' (length=1)       '_vsur5' => string '5' (length=1)       '_vj0s6' => string '6' (length=1)       'july_2' => string '8' (length=1)       '_vn8hh' => string '9' (length=1)       '_vzvl6' => string '10' (length=2)       '_w1a5n' => string '11' (length=2)       '_w2oq0' => string '12' (length=2)       '_w43ah' => string '13' (length=2)       'july_3' => string '15' (length=2)       '_vx2gc' => string '16' (length=2)       '_vyh0t' => string '17' (length=2)       '_wb44i' => string '18' (length=2)       '_wcioz' => string '19' (length=2)       '_wdx9c' => string '20' (length=2)       'july_4' => string '22' (length=2)       '_w6wfb' => string '23' (length=2)       '_w8azo' => string '24' (length=2)       '_w9pk5' => string '25' (length=2)       '_11m5ay' => string '26' (length=2)       '_11njvf' => string '27' (length=2)       'julaugust' => string '29' (length=2)       '_11gj1a' => string '30' (length=2)       '_11hxlr' => string '31' (length=2)       '_11jc64' => string '1' (length=1)       '_11kqql' => string '2' (length=1)       '_11xdua' => string '3' (length=1) 

}

i wondering how i'm supposed go out well?

thanks

use google-apps-script: create web app , pull values via google apps script code. --- suspect option. love proved wrong.

as far know, gdata style api not support getting comments, fonts, color etc. can grab style data getting sheet html. bit messy, works fine.