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();






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.


2 thoughts on “Get objects of all sheets”

Leave a Comment