Export workbook json: JsonOptions no longer available in version 4

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

  • 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.
  • Replied 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.
  • Marked as Answer

    Replied 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.
Need extra support?

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

Learn More

Forum Channels