SpreadJS Documentation
Importing and Exporting to JSON
SpreadJS Documentation > Developer's Guide > Managing Data > Importing and Exporting to JSON

You can import data from or export data to a JSON object using the fromJSON method and toJSON method.

While exporting data to a JSON object, you can set several serialization options for exporting custom data. These options include ignoreStyle, ignoreFormula, rowHeadersAsFrozenColumns and columnHeadersAsFrozenRows.

While importing data from a JSON object, you can set several deserialization options for custom data import. These options include ignoreStyle, ignoreFormula, frozenColumnsAsRowHeaders, frozenRowsAsColumnHeaders and doNotRecalculateAfterLoad.

Earlier versions of SpreadJS cannot load JSON files created with SpreadJS 3.20142.11 or later.

Using Code

This example exports to and imports from a JSON object.

JavaScript
Copy Code

workbook.fromJSON(jsonData,{
ignoreFormula:true,
ignoreStyle:true,
frozenColumnsAsRowHeaders:false,
frozenRowsAsColumnHeaders:false,
doNotRecalculateAfterLoad:true
});


workbook.toJSON({
ignoreFormula:true,
ignoreStyle:true,
rowHeadersAsFrozenColumns:true,
columnHeadersAsFrozenRows:true
});

Using Code

This Visual Studio example loads an ssjson file.

Web.config
Copy Code
<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, visit http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <system.web>
    <compilation debug="true" targetFramework="4.5" />
    <httpRuntime targetFramework="4.5" />
  </system.web>
  <system.webServer>
    <staticContent>
      <mimeMap fileExtension=".ssjson" mimeType="text/plain" />
    </staticContent>
  </system.webServer>
</configuration>
JavaScript
Copy Code

<!DOCTYPE html>
<html lang="en">
<head>
    <title>TestLoad ssjson</title>
    <!--SpreadJS Widgets CSS-->
    <link href="./css/gc.spread.sheets.12.0.0.css" rel="stylesheet" type="text/css" />
         

    <!--jQuery Reference-->
    <script src="http://code.jquery.com/jquery-1.9.1.min.js" type="text/javascript"></script>            

    <!--SpreadJS Widgets JavaScript-->
    <script src="./scripts/gc.spread.sheets.all.12.0.0.min.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(document).ready(function () {                    
            var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
            $.ajax({
                url: "TestFile.ssjson",
                datatype: "json",
                success: function (data) {
                    //here to load ssjson file.
                    spread.suspendPaint();
                    spread.fromJSON(JSON.parse(data));
                    spread.resumePaint();
                },
                error: function (ex) {
                    alert('Exception:' + ex);
                }
            });
        });
    </script>
</head>

<body>

    <div class="container">
        <div class="header">
            <h2>Sample for load .ssjson file</h2>
        </div>
        <div id="ss" style="width: 100%; height: 430px; border: 1px solid gray;"></div>
    </div>
</body>

</html>

See Also