How to generate workbook JSON without sheet data?

Posted by: ernests on 22 June 2020, 1:54 am EST

  • Posted 22 June 2020, 1:54 am EST



    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

    , is it possible to get the Workbook JSON without sheet data, using ```


    SpreadJS ```
    ``` includes an option ```
    ``` that can be used to omit sheet data. 
    Is there something like that in GcExcel?
  • Posted 23 June 2020, 6:39 pm EST


    Unfortunately, we don’t have any option for this currently in GcExcel, neither do we have any workaround for the same.

    Hence, we have posted it as an enhancement request and we will update you once there will be any activity on the enhancement.

    Tracking id for your issue is #DOCXLS-2662.

    Thank you,Reeva

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels