TabSheet.getJSON

Syntax

getJSON(range: PP.Ui.TabSheetRange);

Parameters

range. Cell range converted to JSON object.

Description

The getJSON method converts specified cell range to a JSON object.

Comments

This method returns an Object value.

Example

To execute the example, the HTML page must contain the TabSheet component named tabSheet (see Example of Creating the TabSheet Component). Convert a cell range into a JSON object and show information on serialized data:

// Get a cell range by the specified coordinates
var range = tabSheet.getRange(0, 0, 1, 1);
// Serialize the range to data source format
var result = tabSheet.getJSON(range);
// Output information about serialized data
for (var i in result.Cells.Cell) {
    var cell = result.Cells.Cell[i];
    console.log("Cell value (" + cell.L + "," + cell.T + "): " + cell.CellData.FT)
};

After executing the example the browser console shows values of the range cells as a JSON object:

Cell (0,0) value: 16905
Cell (1,0) value: 3912
Cell (0,1) value: 19281
Cell (1,1) value: 5315