Hi Mark,
You also could read chunks (say 100 rows at a time) instead
of the entire sheet using a query to a cell based feed.
Something like this:
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($this->currKey);
$query->setWorksheetId($this->currWkshtId);
$query->setMinRow(2);
$query->setMaxRow(100);
$feed = $gdClient->getCellFeed($query);
as shown in the PHP Developer's Guide:
http://code.google.com/apis/spreadsheets/docs/1.0/developers_guide_php.html#cellsQueryExample
Or, if you just need to access a small number of rows,
you can use a list feed with a structured query that returns
only rows with cells matching your criteria - just like a db query.
Google's example is if your sheet has columns 'Name' and 'Age',
you could query for all rows with name John and age > 25:
$query->spreadsheetQuery = 'name=John and age>25';
For info about List feed queries see:
http://code.google.com/apis/spreadsheets/docs/1.0/reference.html#list_Parameters
Regards,
Bill Hayes
On Sep 22, 3:18 am, Devraj Mukherjee <dev...@gmail.com> wrote:
> Hi Mark,
>
> > There does seem to be more to it than that but this effect is
> > reproducible. We have created a blank worksheet and added one
> > reference or formula with no problem so size is still a factor but in
> > our main sheet we can double the number of cells with no problem as
> > long as there are no formulae or referenced cells.
>
> > Is it a bug? Is it a feature?
>
> I guess one of the Google staff would be the best people to answer this.
>
> > We are using Zend Framework 1.9.2.
>
> > I would still be grateful for your opinion on the amount of data that
> > you would consider 'reasonable' to extract from a worksheet.
>
> The way I see this is, it really depends on your application and since
> its web based (and written in PHP) the page cycle.
>
> You have to ensure that the page calls are completed within the page
> cycles, so I would be tempted to make as few calls as I could.
>
> On the other hand (if this is an issue for you), if you can get the
> spreadsheet system to do some of the computation for you then you
> could use that to your advantage.
>
> Really depends on the application and the environment.
>
> --
> "The secret impresses no-one, the trick you use it for is everything"
> - Alfred Borden (The Prestiege)
--~--~---------~--~----~------------~-------~--~----~
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 Google-Docs-Data-APIs@googlegroups.com
To unsubscribe from this group, send email to
google-docs-data-apis+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
