Skip to content

Instantly share code, notes, and snippets.

@emmaly

emmaly/getSheetById.gs

Created August 21, 2023 19:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save emmaly/8e0e4e52f635ffc60962b0f16b883499 to your computer and use it in GitHub Desktop.
Save emmaly/8e0e4e52f635ffc60962b0f16b883499 to your computer and use it in GitHub Desktop.
Download ZIP
getSheetById.gs
Raw
getSheetById.gs
/**
* @OnlyCurrentDoc
*/
/**
* @param {SpreadsheetApp.Spreadsheet} spreadsheet
* @param {number} sheetId
* @returns SpreadsheetApp.Sheet
*/
function getSheetById(
sheetId=-1,
spreadsheet=SpreadsheetApp.getActiveSpreadsheet()
) {
return spreadsheet
.getSheets()
.filter((sheet) => sheet.getSheetId() === sheetId)
.shift();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment