I would like to read a Google Spreadsheet like described in the Java Quickstart
https://developers.google.com/sheets/quickstart/java
The Quickstart explaines how to read data from a give range
..... String range = "Class Data!A2:E"; ValueRange response = service.spreadsheets().values() .get(spreadsheetId, range) .execute(); List<List<Object>> values = response.getValues(); ....
But I have the problem that I do not know the Range of the Spreadsheet. The number of columns can change. So how can I read for example all the data of the Sheet without knowing the range?
Regards
Michael
To view the full screen, Click View → Full screen. Spreadsheet will be displayed in full screen mode.
You can specify the whole Sheet as just : String range = "Class Data";
, for a Sheet named Class Data. You can see the output on the Try it part of the spreadsheets.values.get
reference.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With