A, B, C列に値が入っていて列ごとにデータを取得したい
このように
[[a2, a3, a4, a5, ], [b2, b3, b4, b5, ], [c2, c3, c4, c5, ]]
コード.gs
function getMultipleColsData() { var ss_url = 'https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=0'; var ss = SpreadsheetApp.openByUrl(ss_url); var sheet = ss.getSheets()[0]; var lastRow = sheet.getLastRow(); var lastCol = sheet.getLastColumn(); var arrays = []; for(var i = 0; i < lastCol; i++) { var targetCol = i + 1; var range = sheet.getRange(1, targetCol, lastRow, 1); var values = range.getDisplayValues(); var array = values.map(function(array) { return array[0] }); arrays.push(array); } Logger.log(arrays); } |