8̓R[hꗗ

LESSON 22@V[g𑀍삵悤

SECTION 1@A1`ŃZ͈͂擾

A1`ŃZ͈͂擾

function selectRangeByA1Notation() {
  const sheet = SpreadsheetApp.getActiveSheet();
  console.log(sheet.getRange('B2').getA1Notation()); 
  console.log(sheet.getRange('D4:F6').getA1Notation());
}

SECTION 2@sԍƗԍŃZ͈͂擾

sԍƗԍŃZ͈͂擾

function selectRangeByNumbers() {
  const sheet = SpreadsheetApp.getActiveSheet();
  console.log(sheet.getRange(4, 4).getA1Notation());
  console.log(sheet.getRange(4, 4, 3, 3).getA1Notation());
}

LESSON 23@Z̃f[^ǂݏ悤

SECTION 1@1̃Zɏ

ZA1ɁuEҁvƏ

function writeOne() {
  const sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange('A1').setValue('E');
}

SECTION 2@ЂƂ̃Zǂݎ

ZA1̒lsOɕ\

function readOne() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const value = sheet.getRange('A1').getValue();
  console.log(value);
}

SECTION 3@܂Ƃ߂ăZɏ

E҃p[eB[̃o[HP

function writeBatch() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const partyData = [
    ['O', 'HP'],
    ['E', 100],
    ['m', 150],
    ['@g', 80]
  ];
  const range = sheet.getRange(1, 1, 4, 2);
  range.setValues(partyData);
}

SECTION 4 ܂Ƃ߂ăZǂݎ

f[^܂Ƃ߂ēǂݎ

function readBatch() {
  const sheet = SpreadsheetApp.getActiveSheet();
const range = sheet.getRange(2, 1, 3, 2);
  const values = range.getValues();
  console.log(values);
}

SECTION 5@f[^̂Z͈͂擾

f[^̂Z͈͂炷ׂẴf[^擾

function readBatchByDagaRange() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const range = sheet.getDataRange();
  const values = range.getValues();
  console.log(values);    
}

SECTION 6@ŏIsɒlǉ

function addMember() {
  const sheet = SpreadsheetApp.getActiveSheet();
  sheet.appendRow(['m', 90]);
}

SECTION 7@V[gNA

function clearSheet() {
  const sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();
}

LESSON 24@f[^zł܂Ƃ߂悤

SECTION 2@push\bhōsf[^𖖔ɒǉ

E҃p[eB̍ŌɕƂǉ

function usePush() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const values = sheet.getDataRange().getValues();
  values.push(['', 80]);
  sheet.clearContents();
  if (values.length > 0) {
    sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
  }
}

SECTION 3@shift\bhŐ擪f[^폜

function useShift() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const values = sheet.getDataRange().getValues();
  values.shift();
  sheet.clearContents();
  if (values.length > 0) {
    sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
  }
}
