SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage Data / Import and Export to JSON
In This Topic
    Import and Export to JSON
    In This Topic

    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.13.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.13.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