I have some php code that uses the Spreadsheets API to transfer data
from one spreadsheet to another. Right now, it looks something like
the following:
/*GETS DATA FROM ONE SPREADSHEET*/
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($spreadsheetKey1);
$query->setWorksheetId($worksheetId1);
$query->setMinCol(20);
$query->setMaxCol(20);
$query->setMinRow(2);
$query->setMaxRow(13);
$feed = $spreadsheet->getCellFeed($query);
/*PUTS DATA IN A DIFFERENT SPREADSHEET, INCREMENTING THE COLUMN NUMBER
AS IT PASTES CELL VALUES*/
$icol = 2;
foreach($feed as $cellEntry)
{
$updatedCell = $spreadsheet->updateCell("2",$icol,$cellEntry->cell-
>GetText(), $spreadsheetKey1, $worksheetId1);
$icol = $icol + 1;
}
The problem is that this code is very slow when copying large numbers
of cells. Can anyone comment on how this process might be made more
efficient? If an "updateRange" command existed, it would be ideal, I
think. I may attempt to format the spreadsheets such that an
"updateRow" command would work, but would prefer to find something
that works with the spreadsheets "as is".
Any suggestions?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
