Skip to content

Instantly share code, notes, and snippets.

@kinuasa

kinuasa/前のシートを取得.ts

Last active July 10, 2020 05:19
Show Gist options
  • Save kinuasa/d71c4beec338f1c18b2d0d88c0fa978f to your computer and use it in GitHub Desktop.
Save kinuasa/d71c4beec338f1c18b2d0d88c0fa978f to your computer and use it in GitHub Desktop.
Download ZIP
Office Scripts
Raw
前のシートを取得.ts
//前のシートを取得
function main(workbook: ExcelScript.Workbook) {
let currentSheet = workbook.getActiveWorksheet();
let sheet = currentSheet.getPrevious(); //メソッドの引数にtrueを指定すると非表示のシートをスキップ
sheet.getRange("B2").select(); //セルB2を選択
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment