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
Advertisement
Answer
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.