Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getData(id, sheetName) {
- var sheet = SpreadsheetApp.openById(id).getSheetByName(sheetName);
- var rows = sheet.getDataRange().getValues();
- var keys = rows.splice(0, 1)[0];
- return rows.map(function(row) {
- var obj = {}
- row.map(function(item, index) {
- obj[keys[index]] = item;
- });
- return obj;
- });
- }
- function doGet() {
- var data = getData('xxxxxxxxxxxxxxxxxxxxxxx', 'γ·γΌγ1');
- return ContentService.createTextOutput(JSON.stringify(data, null, 2))
- .setMimeType(ContentService.MimeType.JSON);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement