Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reading whole Google Spreadsheet with Sheets API v4 Java

Tags:

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

like image 850
Michael Meyer Avatar asked Dec 03 '16 10:12

Michael Meyer


People also ask

How do I view an entire spreadsheet in Google Sheets?

To view the full screen, Click View → Full screen. Spreadsheet will be displayed in full screen mode.


1 Answers

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.

like image 68
Bardy Avatar answered Sep 20 '22 01:09

Bardy