search

Iwark / spreadsheet

Google Go (golang) library for reading and writing spreadsheet files on Google Docs.
MIT License
382 stars 53 forks source link

whitelist of sheets for loading #39

Closed tpam28 closed 5 years ago

tpam28 commented 5 years ago

Hello everyone.

I have a spreadsheet that contain about 40 sheets. Many of them contain 2-5k rows. Method FetchSpreadsheet performed about 15 seconds. Even if my program wants load one small sheet it wait for loading and unmarshaling all data from the spreadsheet. I’ve created small fixes which add methods add a title to a whitelist and remove a title from the whitelist. Them used filter range but i use those methods only as whitelist of sheets. This solution gives a result of 0.5-0.7 seconds for one sheet.

tpam28 commented 5 years ago

sorry i didn't see AddNamedRange method.