c# - Google Sheets - How to get index of last row/column

Question

I'm using the Google Sheets API to read and store some data, and have a sheet who's dimensions may not be known at runtime. When using a C# application, how can I get, in A1 notation, the last row and column of data?

Found some other threads suggesting using a very large range (A1:ZZ2000000), but I would rather avoid doing that - it seems wasteful.

I've written some custom functions which can get these indexes, but I'm not sure on how to use that in an external C# application.

Thanks!

question from:https://stackoverflow.com/questions/65911480/google-sheets-how-to-get-index-of-last-row-column

Answer 1

Waitting for answers