如何从谷歌表中获取数据作为字典数组

Question

我很难将行和列中包含的数据格式化为字典数组。以下是我试图实现的格式：[[id: "abchdha", name: "Orange", health: "fruit", price: 50], [id: "123fsf", name: "Apple", health: "fruit", price: 50]]这是我的谷歌表格脚本：var secret = "mysecretcode"function getFirebaseUrl(jsonPath) {  /*  We then make a URL builder  This takes in a path, and  returns a URL that updates the data in that path  */  return (    'myfirebaselink' +    jsonPath +    '.json?auth=' +    secret  )}function syncMasterSheet(excelData) {  /*  We make a PUT (update) request,  and send a JSON payload  More info on the REST API here : https://firebase.google.com/docs/database/rest/start  */  var options = {    method: 'put',    contentType: 'application/json',    payload: JSON.stringify(excelData)  }  var fireBaseUrl = getFirebaseUrl('masterSheet')  /*  We use the UrlFetchApp google scripts module  More info on this here : https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app  */  UrlFetchApp.fetch(fireBaseUrl, options)}function startSync() {  //Get the currently active sheet  var sheet = SpreadsheetApp.getActiveSheet()  //Get the number of rows and columns which contain some content  var [rows, columns] = [sheet.getLastRow(), sheet.getLastColumn()]  //Get the data contained in those rows and columns as a 2 dimensional array  var data = sheet.getRange(1, 1, rows, columns).getValues()  syncMasterSheet(data)}我需要将函数startSync()设置为var data等于我想要的格式。:)