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. .
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":[]
}
var json = SHEET_API.getJsonData(SHEET_API_HD);
alert(Ext.encode(json));
You can encode and save the json data into your server.