Thanks.. that did solve all my troubles. I was doing cellfeed updates in a batch.
Only issue now is the size restriction inn the table size. Any Ideas on when the beta version will let our tables grow? This would be used for a research lab at school, could that be used as a test case to show off Google's ability to have large data sets? I do notice about 300ms to add a row, and about max of 5 seconds tp add row if users are watching the spreadsheet -- great job dealing with complex concurrency and ajax display! Brad On Dec 22 2008, 5:45 pm, Trevor Johns <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
