Pages

Friday, November 12, 2021

Google Sheets Create Json Api

function doGet(e) {
  var sheet = SpreadsheetApp.getActive();
  var nse = sheet.getSheetByName("NSEE");
  var data =[];
  var rlen=nse.getLastRow();
  var clen=nse.getLastColumn();
  var rows = nse.getRange(1,1,rlen,clen).getValues();
  for(var i=1;i<rows.length;i++ ){
    var datarowrows[i];
    var record ={};
    for (var j=0;j<clen;j++){
      record[rows[0][j]] = datarow[j];

    }
    data.push(record);
  }
  console.log(data);
  var result = JSON.stringify(data);
  return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON);
  
 }

No comments:

Post a Comment

KeyPoints-Series-1

  The Android architecture has the Main Thread AKA UI thread, which updates the UI after every  16ms  frame.