Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. function getData(id, sheetName) {
  2. var sheet = SpreadsheetApp.openById(id).getSheetByName(sheetName);
  3. var rows = sheet.getDataRange().getValues();
  4. var keys = rows.splice(0, 1)[0];
  5. return rows.map(function(row) {
  6. var obj = {}
  7. row.map(function(item, index) {
  8. obj[keys[index]] = item;
  9. });
  10. return obj;
  11. });
  12. }
  13.  
  14. function doGet() {
  15. var data = getData('xxxxxxxxxxxxxxxxxxxxxxx', 'γ‚·γƒΌγƒˆ1');
  16. return ContentService.createTextOutput(JSON.stringify(data, null, 2))
  17. .setMimeType(ContentService.MimeType.JSON);
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement