且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用GAS使用内置的电子表格功能

更新时间:2023-08-25 08:10:52

不幸的是,这是不是可能的。这是Apps Script最古老的请求之一,请参阅问题26 - 启用脚本以使用标准电子表格功能


I just start using a spreadsheet programming with GAS but can't find the answer to my trivial question.

I want to obtain the highest number in a column in a spreadsheet.
Opening the spreadsheet and obtaining a range is not a problem, but I don't know how to use built-in spreadsheet functions like MAX()

   var ss = openSpreadsheetByName(MyName);
   var sheet = ss.getSheets()[0];
   var lastRow = sheet.getLastRow();
   var range = sheet.range(1, 1, lastRow, 1);

Now I would like to use var maxId = range.max(); or var maxId = max(range);
In general I would like to use built-in spreadsheet functions. But don't know how.

Unfortunately, this is not possible. This is one of the oldest requests for Apps Script, see issue 26 - Enable scripts to use standard spreadsheet functions.