I am trying to insert a row with cells in it. It's all string
eg. in Python
values = [[ "col1", "col2", ......."col500" ]]
body = {'values': values'}
result = service.spreadsheets().values().update(spreadsheetId=spreadsheetId,
range=range, body=body,
valueInputOption='RAW').execute()
then i got
File
"/Users/danielng/Documents/workspace/git/eglpy/eglpenv/lib/python3.4/site-packages/oauth2client/util.py",
line 137, in positional_wrapper
return wrapped(*args, **kwargs)
File
"/Users/danielng/Documents/workspace/git/eglpy/eglpenv/lib/python3.4/site-packages/googleapiclient/http.py",
line 838, in execute
raise HttpError(resp, content, uri=self.uri)
googleapiclient.errors.HttpError: <HttpError 400 when requesting
https://sheets.googleapis.com/v4/spreadsheets/1odCsvhy2ObJkcYYFxyTx29xGm7EDswqrbydyy91S874/values/bridesmaid%20gifts%21A1?alt=json&valueInputOption=RAW
returned "This action would increase the number of cells in the workbook above
the limit of 2000000 cells.">
I don't think my request is exceeding 2M cells yet. How come I am
receiving such error? Is there way to turn on more debugging?
--
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.
