How to generate workbook JSON without sheet data?

How to generate workbook JSON without sheet data?

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

• 

  ernests

  • Post Options:
  • Link
    Copy

  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?

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 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