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);
}
|
