Guest User

Untitled

a guest
Jul 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. $query = new Zend_Gdata_Spreadsheets_ListQuery();
  2. $query->setSpreadsheetKey($spreadsheetKey);
  3. $query->setWorksheetId($worksheetId);
  4. $listFeed = $spreadsheet->getListFeed($query);
  5.  
  6. //$rowData = $listFeed->entries;
  7.  
  8. foreach ($listFeed as $listEntry) {
  9. $rowData = $listEntry->getCustom();
  10. $newRow = array();
  11. //Populate the row data
  12. foreach($rowData as $field) {
  13. $newRow[$field->getColumnName()] = $field->getText();
  14. }
  15. //Add an array key for the new column
  16. $newRow['aug2011'] = 'Some data here';
  17. $spreadsheet->updateRow($listEntry, $newRow)
  18. }
  19.  
  20. exit();
Add Comment
Please, Sign In to add comment