Sample Code

Get sheet tab data

Document -> Sample Code for Using APIs -> Sample code for sheet -> Get sheet tab data

In the method getSheetTabData of SheetAPI, it allows user get the sheet tab data. .

Here comes the code example


var json = SHEET_API.getSheetTabData(SHEET_API_HD);
alert(Ext.encode(json));

Return back is an array of sheet json data object as following. You can get sheet id, sheet name, color from this array.

[{
       id: 1,
       name: 'sheet 1',
       actived: true,
       color: 'red',
},{
       id: 2,
       name: 'sheet 2',
       color: 'red',
}]