谷歌应用程序脚本-我怎么能得到JSON?

Question

我有脚本:

function mySheet(e){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetId = ss.getId();
var name = ss.getName();
var sheetName = ss.getSheetName();
var maxCol = ss.getLastColumn();
var maxRow = ss.getLastRow();
var data = ss.getRange(sheetName+"!A1:"+maxCol+maxRow).getValues();
Logger.log(sheetId +" "+ name +" "+ JSON.stringify(data));
}

我有json值，但我需要json像$service->spreadsheets_values->get($ spreadsheet_id， $range)返回…我怎么能做到呢?我需要这样的数据:{"majorDimension":"ROWS","range":"'Sheet1'!A1:Z3","values":...}我搜索了，但找不到方法…

Answer 1

用户表单API

https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/Sheet1!A1:Z3

Sheets.Spreadsheets.Values.get(ss.getId(), 'Sheet1!A1:Z3')