Have you tried with R1C1 notation instead? So instead of A6:D1113 you would use R6C1:R1113C4
On Thu, Jan 8, 2015 at 10:31 PM, <[email protected]> wrote: > Here is my request: > > token = gdata.gauth.OAuth2Token( > client_id= CLIENT_ID, > client_secret= CLIENT_SECRET, > scope='https://spreadsheets.google.com/feeds', > user_agent="TOLA", > access_token = "ACCESS_TOKEN", > refresh_token = "REFRESH_TOKEN") > gd_client = > gdata.spreadsheets.client.SpreadsheetsClient(source="TOLA") > gd_client = token.authorize(gd_client) > > feed = gd_client.get_worksheets(sprd_key) > id_parts = feed.entry[0].id.text.split('/') > wrksht_key = id_parts[len(id_parts) - 1] > > range = "A6:D1113" > cellq = gdata.spreadsheets.client.CellQuery(range=range, > return_empty='true') > cells = gd_client.GetCells(sprd_key, wrksht_key, q=cellq) > batch = gdata.spreadsheets.data.BuildBatchCellsUpdate(sprd_key, > wrksht_key) > n = 1 > for cell in cells.entry: > cell.cell.input_value = str(n) > batch.add_batch_entry(cell, cell.id.text, > batch_id_string=cell.title.text, operation_string='update') > n = n + 1 > gd_client.batch(batch, force=True) > > > On Thursday, January 8, 2015 at 6:19:25 PM UTC-8, LauraBeth Lincoln wrote: >> >> Can you include your request? >> On Jan 8, 2015 6:47 PM, <[email protected]> wrote: >> >>> I use the Google python gdata client library in order to do batch >>> updates to a Google Spreadsheet. However, Google Spreadsheet, by default, >>> has 1000 rows. When my batch update exceeds that limit, then I get the >>> following error message: >>> >>> "Server responded with: 400, Invalid query parameter value for range." >>> >>> >>> The stack trace is: >>> >>> " >>> >>> Traceback: >>> File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" >>> in get_response >>> 112. response = wrapped_callback(request, >>> *callback_args, **callback_kwargs) >>> File >>> "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py" >>> in _wrapped_view >>> 22. return view_func(request, *args, **kwargs) >>> File "/Users/mkhan/dev/tola/htdocs/feed/views.py" in google_export >>> 278. cells = gd_client.GetCells(sprd_key, wrksht_key, q=cellq) >>> File "/usr/local/lib/python2.7/site-packages/gdata/spreadsheets/client.py" >>> in get_cells >>> 376. **kwargs) >>> File "/usr/local/lib/python2.7/site-packages/gdata/client.py" in get_feed >>> 640. **kwargs) >>> File "/usr/local/lib/python2.7/site-packages/gdata/client.py" in request >>> 319. RequestError) >>> >>> Exception Type: RequestError at /google_export/ >>> Exception Value: Server responded with: 400, Invalid query parameter value >>> for range. >>> >>> " >>> >>> >>> I searched through StackOverflow as well as this Google Group but have not >>> found an answer. I'd appreciate any help you provide. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Google Spreadsheets API" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- -lb -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
