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

    Hello!

    Background

    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.

    Question

    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.toJSON
    ?

    SpreadJS
    Workbook.toJSON
    includes an option
    includeBindingSource
    that can be used to omit sheet data.

    Is there something like that in GcExcel?
  • Replied 23 June 2020, 6:39 pm EST

    Hello,

    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