Google Sheets API v4 - How to get the last row with value?

android google-sheets google-drive-api google-spreadsheet-api
seba123neo picture seba123neo · May 19, 2016 · Viewed 15.2k times · Source

How to get the last row with value in the new Google Sheets API v4 ?

i use this to get a range from a sheet:

mService.spreadsheets().values().get("ID_SHEET", "Sheet1!A2:B50").execute();

how to detect the last row with value in the sheet ?

Answer

A Paracha picture A Paracha · May 21, 2016

You can set the range to "A2:D" and this would fetch as far as the last data row in your sheet.

Related questions

Android - Google Spreadsheet Api

I can't get which libs i should use for developing an Android app that menages Google spreadsheet. I need connecting, copying, editing, reading from a user spreadsheet but i can't understand today which is the way. Google Drive Api : https://…

Read More
How do I connect Android apps with Google Sheets spreadsheets?

I'm trying to do an Android app that needs to work with Google spreadsheet API. I'm new in this, so I'm starting with the version 3 of the api: https://developers.google.com/google-apps/spreadsheets/ I followed all the steps, downloaded …

Read More
Google Sheets API: How to find a row by value and update it's content

I am working on an Android application that uses a Google Spreadsheet as a database. The application should GET, APPEND and UPDATE values in a spreadsheet, using the Sheets API v4. The first two functions are working fine but I …

Read More