7̓R[hꗗ

LESSON 20@XvbhV[g̓q\m낤

SECTION 3@JĂXvbhV[g擾

JĂXvbhV[g擾

function getMySpreadsheet() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  console.log(`u${ss.getName()}v擾ł`);
}

SECTION 4@URL ŃXvbhV[g擾

URLŃXvbhV[g擾

function getByUrl() {
  const ss = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/xxxxx/edit/edit?gid=0#gid=0');
  console.log(`u${ss.getName()}v擾ł`);
}

SECTION 5@IDŃXvbhV[g擾

IDŃXvbhV[g擾

function getById() {
  const ss = SpreadsheetApp.openById('XXX...');
  console.log(`u${ss.getName()}v擾ł`);
}

LESSON 21@V[g̑悤

SECTION 2@OŃV[gw肷

uV[g1v擾

function getSheetByName() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName('V[g1');
  console.log(`u${sheet.getName()}v擾ł`);
}

SECTION 3@V[gIDŎw肷

V[gIDu0v擾

function getSheetById() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetById(0); 
  console.log(`u${sheet.getName()}v擾ł`);
}

SECTION 4@ׂẴV[guzvƂĎ擾

V[g܂Ƃ߂Ď擾

function getSheetsArray() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheets = ss.getSheets();
  for (const sheet of sheets) {
   console.log(`u${sheet.getName()}v擾ł`);
  }
}

SECTION 5@ANeBuȃV[g擾

ANeBuȃV[g擾

function getActiveSheet() {
  const sheet = SpreadsheetApp.getActiveSheet();
  console.log(`u${sheet.getName()}v擾ł`);
}
