はてなブックマーク

function getData(sheetName) { var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName); var rows = sheet.getDataRange().getValues(); return rows.map(function(row) { var obj = {}; obj.type = "Feature" obj.properties = {}; obj.properties.name = row[0]; //A列 obj.geometry = {}; obj.geometry.type = "Point"; obj.geometry.coordinates = []; obj.geometry.coordinates.push(row[2],row[1]);//C列,B列 retu