Posted 22 June 2020, 1:54 am ESTHello!
I would like to use GxExcel on the backend to generate JSON from Excel files for the SpreadJs to consume in Frontend.
We are sometimes dealing with big Excel files (over 20Mb).
So I want to employ the following strategy on the Frontend:
- load the workbook JSON (includes styles, global named ranges etc)
- load the sheet data per sheet with separate requests
Of course, recalculation and editing will be turned off.
Since it's possible to get sheet data per Worksheet with
Worksheet.toJSON, is it possible to get the Workbook JSON without sheet data, using
Workbook.toJSONincludes an option
includeBindingSourcethat can be used to omit sheet data.
Is there something like that in GcExcel?