Guest User

Untitled

a guest
Jun 24th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. index_sheet = 'sheet id here'
  2. index_data = service.spreadsheets().get(spreadsheetId=index_sheet).execute()
  3. fileinfo = index_data['sheets']
  4. for i in range(len(fileinfo)):
  5. sheet_title = fileinfo[i]['properties']['title'].encode('utf-8')
  6. #error on the line below
  7. data = service.spreadsheets().values().get(spreadsheetId=index_sheet, range=sheet_title).execute()
  8.  
  9. googleapiclient.errors.HttpError: <HttpError 400 when requesting https://sheets.googleapis.com/v4/spreadsheets/sheet id here/values/bworksheet name here?alt=json returned "Unable to parse range: b'worksheet name here'">
Add Comment
Please, Sign In to add comment