How load a specific sheet from a Spreadsheet

Question

I have a Spreadsheet that contains a lot of sheets, and I need to load one of these sheets, how can I do that?

Here is a photo of the sheets in my Spreadsheet

Here is my idea how to do it:

var sheet = SpreadsheetApp.openById(index).getSheetByName('Geração de Demanda');

Should that be working?

Answer 1

You're almost there... what you want is to make that sheet 'active' so try this :

var sheet = SpreadsheetApp.getActiveSpreadsheet();
SpreadsheetApp.setActiveSheet(sheet.getSheetByName('Geração de Demanda'))