Why not login to Qiita and try out its useful features?

We'll deliver articles that match you.

You can read useful information later.

0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

【GAS初心者】スプレッドシートの中にあるシート数を取得する(GAS)

Last updated at Posted at 2020-07-28

シートがたくさんあって、何があるかわからない.........

そんなことはないでしょうか。

カウントの仕方は簡単。

結論

結論
.getNumSheets();

具体例

シート数を取得
function sample() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet_num = sheet.getNumSheets();
  Logger.log('シート数は:'+ sheet_num);
}
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up

Qiita Advent Calendar is held!

Qiita Advent Calendar is an article posting event where you post articles by filling a calendar 🎅

Some calendars come with gifts and some gifts are drawn from all calendars 👀

Please tie the article to your calendar and let's enjoy Christmas together!

0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

Login to continue?

Login or Sign up with social account

Login or Sign up with your email address