getSheets

gets all sheets of the spreadsheet

array getSheets();

Returns

arrayan array of sheets objects

Example

spreadsheet.getSheets();
// ->  [{name: "sheet1", id: "u1614669331194"}, …]

Details

Each sheet object includes the name and id attributes of the sheet.

Change log

added in v4.1

Back to top