Google Spreadsheet. How to find out the number of the last "non-empty" line?

Question

PHP

Get the number of rows on the sheet and loop through the first column for user data. I didn’t come up with anything smarter :( But somehow it looks clumsy. And it’s not universal. Maybe there is a function in the API, but I’m blind?

Answer 1

https://developers.google.com/apps-script/referenc...