| Spread.Sheets Documentation > Developer's Guide > Managing Data > Importing and Exporting to JSON |
You can import or export data to JSON objects or files (JavaScript Object Notation). The JSON filename extension is .json.
![]() |
Earlier versions of Spread.Sheets cannot load JSON files created with SpreadJS 3.20142.11 or later. |
This example exports to and imports from a JSON object.
| JavaScript |
Copy Code
|
|---|---|
| activeSheet.getCell(0,0).value(123); var jsonStr = null; //export jsonStr = JSON.stringify(spread.toJSON()); //import spread.fromJSON(JSON.parse(jsonStr)); alert(jsonStr); //alert(jsonStr[0]); |
|
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> <!--jQuery Reference--> <!--Spread.Sheets Widgets JavaScript--> <body> <div class="container"> </html> |
|