How can I get the number of rows in a Google Spreadsheet using api?

google-docs-api google-spreadsheet-api
canerbalci picture canerbalci · May 10, 2013 · Viewed 14.8k times · Source

Is it possible to fetch the number of filled rows without fetching the whole spreadsheet, or find the first empty row number?

I am using the python api wrapper if it matters.

Answer

eddyparkinson picture eddyparkinson · May 13, 2013

The main google API docs say you can do it using the WorksheetFeed. So must be possible from python. https://developers.google.com/google-apps/spreadsheets/#retrieving_information_about_worksheets

Related questions

How do I export the revision history of a gdoc to git?

I have a spreadsheet in google docs that I'd want to integrate in a git workflow (and push to github). Are there any tools (or even libraries that are gdoc version aware) that do, or help me do, that? I …

Read More
How to programmatically create a Google Docs spreadsheet WITH CONTENT?

I have found multiple StackOverflow questions dealing with how to create or edit Google Doc spreadsheets using the Google Spreadsheets API, or older API's. However, this Spreadsheets API seems to be part of the "gdata" library, which to my understanding …

Read More
Download/Export Public Google Spreadsheet as TSV from Command Line?

I have a public (published) Google spreadsheet that I’m trying to download programmatically in TSV form. In my browser, with a Google login active, for some actual key $key, https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=$key&…

Read More