Export workbook json: JsonOptions no longer available in version 4

Export workbook json: JsonOptions no longer available in version 4

Posted by: cristian.pilon on 5 March 2021, 5:44 am EST

• 

  cristian.pilon

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 March 2021, 5:44 am EST

  Hi Grape City team.

  We were working on a way to load workpapers per sheet. We had a code using version 3 of Documents for Excel where we loaded a workbook using the following option:

  data = workbook.ToJson(new GrapeCity.Documents.Excel.JsonOptions { ContentType = JsonContentType.WorkbookSkeleton })
  

  We tried to achieve the same using version 4 but it looks like that option is no longer available (now the ToJson method expects a SerializationOptions object that does not have the WorkbookSkeleton option).
  
  Is there a way to load only the skeleton of the workbook instead of processing the whole workbook?

  Thanks in advance.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 7 March 2021, 9:25 pm EST

  Hi Cristian,

  We too can observe the same behavior at our end and escalated this to the developers. We will let you know as soon as we get any update on this from the developers’ end.
  
  [Internal Tracking ID: 3831]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 March 2021, 7:39 pm EST

  Hi Cristian,

  As per the developers, the feature will be get added to the GcExcel API in the future release.
  
  As a workaround, you can remove sheet nodes from the result after calling workbook.ToJson() method.

  Regards,
  
  Prabhat Sharma.