Get objects of all sheets

On the other day, I posted a tip to get a sheet object by sheet’s name. If you want to know how to get a sheet object by sheet’s name, please refer the following post;

Get a sheet object by name

So let’s look into how to get all sheets’ object.

 

Source code

function getSheetsOjbects(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
}

 

Format

SpreadsheetObject.getSheets()

 

Returns

Sheets’ Objects

 

How to identify an object of per a sheet?

It needs to add an index on the end of sheets’ objects. The index values starts from 0.

SpreadsheetOjbect.getSheets()[index]

2 thoughts on “Get objects of all sheets”

Leave a Comment