How to get all the filled data in the table in google sheets api?-CodePudding

Please tell me how in the Google Sheets API you can not manually get the range of the entire table located on a certain sheet. I have a table in which the number of columns can change, but I still have to get information from it.

sheet = service.spreadsheets().values().get(
spreadsheetId=spreadsheet_id, range='???').execute()

CodePudding user response：

You can you sheet.getDataRange() to get range of the visible data on your spreadsheet.

CodePudding user response：

solution:

sheet = service.spreadsheets().values().get(
         spreadsheetId=spreadsheet_id,
         range='Sheet1',
         majorDimension='ROWS').execute()