ImportExcelData (GAS)

function ImportExcelData() {

  let sheetName;
  let excelFileId;

  for (let i = 0; i &lt; 3; i++) {

    switch (i) {
      
      case 0:
        sheetName = "宛先";
        excelFileId = "1GHanq7V3b7XQ6A7K0ZQKZm5TeHMkpKoS";
        break;

      case 1:
        sheetName = "対象者";
        excelFileId = "1UXLRyr6KiECut7dqAcE5Bl987D3I6ijq";
        break;

      case 2:
        sheetName = "CC";
        excelFileId = "1ofhs4SsHirKCPLQO9tJS3Pxp56dxGTkm";
        break;

    }

    DataTransfer(sheetName, excelFileId);
    
  }

}

function DataTransfer(vSheetName, vExcelFileID) {

  let ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(vSheetName);
//  let excelFileId = vExcelFileID;
  let excelFile = DriveApp.getFileById(vExcelFileID);
  let blob = excelFile.getBlob();
  let data = Utilities.parseCsv(blob.getDataAsString('UTF-8'));

  sheet.getRange(1, 1, data.length, data&#91;0].length).setValues(data);

}

function ImportExcelData() {

let sheetName;

let excelFileId;

for (let i = 0; i < 3; i++) {

switch (i) {

case 0:

sheetName = "宛先";

excelFileId = "1GHanq7V3b7XQ6A7K0ZQKZm5TeHMkpKoS";

break;

case 1:

sheetName = "対象者";

excelFileId = "1UXLRyr6KiECut7dqAcE5Bl987D3I6ijq";

break;

case 2:

sheetName = "CC";

excelFileId = "1ofhs4SsHirKCPLQO9tJS3Pxp56dxGTkm";

break;

}

DataTransfer(sheetName, excelFileId);

}

function DataTransfer(vSheetName, vExcelFileID) {

let ss = SpreadsheetApp.getActiveSpreadsheet();

let sheet = ss.getSheetByName(vSheetName);

// let excelFileId = vExcelFileID;

let excelFile = DriveApp.getFileById(vExcelFileID);

let blob = excelFile.getBlob();

let data = Utilities.parseCsv(blob.getDataAsString('UTF-8'));

sheet.getRange(1, 1, data.length, data[0].length).setValues(data);

}

2023-01-21