Skip to content

Instantly share code, notes, and snippets.

@kinuasa

kinuasa/最後のシートを取得.ts

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