You can use the json string to initialize spreadjs product GrapeCity Documents for Excel export a worksheet to json string new_workbook = new () įoreach (IWorksheet worksheet in workbook.Worksheets) GrapeCity Documents for Excel import an excel file ToJson&FromJson can be used in combination with spreadjs product: Refer to the following example code to export and import json string of a worksheet.
Hence, GcExcel does not get all the settings when imported from ssjson.
Importing worksheet json to another workbook on server might cause data loss or conflict.Further, the json string of the worksheet can be transfered to client to be loaded in SpreadJS. The Excel file can be opened in GcExcel and the json string of a worksheet can be exported using the ToJson method. It also enables you to view a large Excel file in SpreadJS. The worksheet can also be exported or imported to the same or another workbook. Similarly, you can also import a json string to your worksheet using the FromJson of the IWorksheet interface. You can export the information in a worksheet to a json string using the ToJson method of the IWorksheet interface. Import and Export JSON String for Worksheet
For more information, see Import and Export from JSON without Worksheets. Note: To get better performance in case of large workbooks with many worksheets having complex formula, you can export and import the workbook and worksheets to separate JSON streams.
0 kommentar(er)
