One option would be to use the Drive API to export the entire spreadsheet as an XLS or Open Office spreadsheet and then use a library to read that file in your application and access the data.
B - Eric On Thursday, December 10, 2015 at 10:11:00 AM UTC-5, Tomas Langer wrote: > > Hi, > I use java client to retrieve all lines of all sheets of a workbook. The > workbook has around 40 sheets, each up to hundreds of lines. > > Using the ListFeed (for each worksheet): > ListFeed listFeed = > getSpreadsheetService().getFeed(worksheet.getListFeedUrl(), ListFeed.class); > > for each sheet is quite slow - it takes tens of seconds to read all the > data from the workbook even on a very fast network. > > Is there some way how to get all the lines of a sheet in a single call? Or > even the whole workbook? > > > Thanks a lot, > Tomas > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
