CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
user718229
user718229

Reputation: 573

Output an array to the first sheet

Id like to output the list of sheet names obtained from this loop, to the first sheet 

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetNameArray = [];
var sheets = ss.getSheets();
for (var i = 0; i < sheets.length; i++) {
  sheetNameArray.push(sheets[i]);
}

Upvotes: 0

Views: 949

Answers (1)

Tanaike
Tanaike

Reputation: 201388

Is this what you want to do? This script imports sheet names in the opened spreadsheet to the current sheet.

Flow :

  1. Retrieve sheets from the opened spreadsheet.
  2. Create 2 dimensional array to using setValues().
  3. Import the created data to the current sheet.

Sample script :

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
var sheetNameArray = sheets.map(function(e){return [e.getName()]});
ss.getActiveSheet().getRange(1, 1, sheetNameArray.length, sheetNameArray[0].length).setValues(sheetNameArray);

Note :

  • If you want to import the sheet name to a row, please use this var sheetNameArray = [sheets.map(function(e){return e.getName()})]; instead of var sheetNameArray = sheets.map(function(e){return [e.getName()]});

Reference :

If I misunderstand your question, I'm sorry.

Upvotes: 1

Related Questions