ImportExcelData (GAS)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | 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); } |