All these spreadsheets have the same format. My requirement is to get a particular cell range (say A1:B5) from each spreadsheet and display them in a tabular format (column header is the file name, and the rows would be the data in the cell range).
I tried Zoho reports, and to create a table I can use only one spreadsheet. I don't want to create a table for each and every spreadsheet.
Is there any other way that I can fulfil my requirement? Is there a way that I can write a script (something similar to Google Apps Script in google drive) to get this done?
Your support is highly appreciated.
Thanks