Managing Sheet with APIs

SheetAPI.getJsonData



SheetAPI.getJsonData method is used to get Json data from sheet. This method will get data from panel as Json format, and you can call your method to submit it to your server. .

SHEET_API.getJsonData( hd, compress )

Parameters The handle information of the Sheet application your created. True or False. If true, the returned json cell format is:
cells: [{
    i: 5, 
    x:1, 
    y:1, 
    c:true, 
    j:{data:"=sum(1,2)"},
}]
else, the returned json cell format will be:
cells: [{
    sheet: 5, 
    row:1, 
    col:1, 
    cal:true, 
    json:{data:"=sum(1,2)"},
}]

Returns

The array of list json object

{
        "sheets": [
           {"id":0,"name":"Sheet1",actived:true},
           {"id":1,"name":"Sheet2"},
           {"id":2,"name":"Sheet3"}
        ],
        "cells":[{
		    sheet: 1, 
		    row:1, 
		    col:1, 
		    cal:true, 
		    json:{data:"=sum(1,2)"},
        }],
        "floatings":[],
        "fileConfig":[]
}

Example code


var json = SHEET_API.getJsonData(SHEET_API_HD);
alert(Ext.encode(json));
 
You can encode and save the json data into your server.

 

 


Copyright © FeyaSoft Inc. All rights reserved.