2

I'm using Zend_Gdata_Spreadsheets to interact with a Google Docs spreadsheet in PHP. I need to modify many cells in the spreadsheet, so I use the updateCell() method:

Example: $spreadsheetService->updateCell(1, 1, "hello", $spreadSheetKey, $worksheetId);

My code works fine for updating a cell. But I need to update many cells (usually 20 or 30 cells) and if I update them one by one (using the code above), it makes a separate api call for each cell update. This can take a LONG time to run if I have lots of cells to udpate.

Is there a way for me to update a batch of cells all at once so it's more efficient?

matt
  • 670
  • 2
  • 9
  • 18

1 Answers1

1

Just use the insertRow function to insert data row by row. Example code:

$key ="YOUR_SPREADSHEET_KEY"

$row = array(
"a" => "A column value",
"b" => "B column value",
"c" => "C column value",
"d" => "D column value"
);

$spreadSheetService->insertRow($row, $key);

Important: in this example you have to edit the first row of your target spreadsheet manually. You have to write "a" in the first column, "b" in the second, etc until you write "d" in the fourth column. Note these are the keys of the associative array we have to pass to insertRow method.

Roger
  • 600
  • 5
  • 18
  • If you want more info you should check out this URL: http://www.ibm.com/developerworks/library/x-googledata2/index.html – Roger Mar 14 '13 at 17:23