On 2008-12-20 15:50:25 -0800, brad zdanivsky <[email protected]> said:
>
>
>
> Using the example code for a cell feed:
>
> public void setCell(int row, int col, String formulaOrValue)
> throws IOException, ServiceException {
>
> CellEntry newEntry = new CellEntry(row, col, formulaOrValue);
> service.insert(cellFeedUrl, newEntry);
> }
>
> ----------------------------------------
>
> When I reach the end of my spread sheet, these exceptions get thrown..
> until I manually add blank rows from google docs App.
To solve this, you'll need to retrieve the metadata for the worksheet
and change the number of rows.
To do this:
1. Download the worksheet's metadata feed:
http://spreadsheets.google.com/feeds/worksheets/[key]/private/full/[sheet]
2. Modify the value of <gs:rowCount> in the returned XML.
3. Use HTTP PUT to send the modified XML to the URL listed in the
entry's <link rel="edit" type="application/atom+xml" href="..."/>
element.
> What is the best approach for sending in massive amounts of data? My
> app sends a batch of data every few seconds.
You may want to consider using a list-based feed, rather than a
cell-based feed. The list-based feed will create new rows as needed,
and will likely require fewer reqests if all you're doing is writing
out log entries, since you'd be writing entire rows at a time.
--
Trevor Johns
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
