找不到范围，Google Apps脚本Google表

发布于 2025-01-26 20:55:41 字数 751 浏览 1 评论 0原文

程序脚本中为此类函数构建自定义范围

我正在尝试在Google表的应用但是我已经搜寻了很多，似乎找不到它。谁能散发一些灯光？

谢谢你，瑞安

SORT_ORDER = [
{column: 118, ascending: true},  // 3 = column number, sorting by descending order
{column: 119, ascending: true}, // 1 = column number, sort by ascending order 
{column: 117, ascending: true},
{column: 25, ascending: true}
];

function sortProductionLog(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(SHEET_NAME);
  var LastRow_WithValue = sheet.getLastRow();
  var LastColumn_WithValue = sheet.getLastColumn();
  var buildRange = "4,1," + (LastRow_WithValue - 4) + "," + (LastColumn_WithValue - 1);
  var range = sheet.getRange(buildRange);
  ss.toast(buildRange);
  range.sort
}

原文

I'm trying to build a custom range for this sort function in an Apps Script for Google Sheets but I keep getting the error: "Exception: Range not found; sortProductionLog @ macros.gs:15"

I'm sure this is something basic but I have searched far and wide and can't seem to find it. Can anyone shed some light?

Thank you,
Ryan

SORT_ORDER = [
{column: 118, ascending: true},  // 3 = column number, sorting by descending order
{column: 119, ascending: true}, // 1 = column number, sort by ascending order 
{column: 117, ascending: true},
{column: 25, ascending: true}
];

function sortProductionLog(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(SHEET_NAME);
  var LastRow_WithValue = sheet.getLastRow();
  var LastColumn_WithValue = sheet.getLastColumn();
  var buildRange = "4,1," + (LastRow_WithValue - 4) + "," + (LastColumn_WithValue - 1);
  var range = sheet.getRange(buildRange);
  ss.toast(buildRange);
  range.sort
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

深海少女心 2025-02-02 20:55:41

问题是您正在尝试使用字符串“ 4，1，...”作为.getRange（）参数。该函数最多占四个数字，或“ A1表示法”中的一个字符串。

来源：

。列，numrows，numcolumns）

建议修复：

var buildRange = [4,1, LastRow_WithValue - 4, LastColumn_WithValue - 1];
var range = sheet.getRange(...buildRange);

此外，这是一个合并版本：

function sortProductionLog() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME)
  sheet.getRange(4, 1, sheet.getLastRow()-4, sheet.getLastColumn()-1)
       .sort(SORT_ORDER)
}

The problem is you are trying to use a string "4, 1, ..." as the .getRange() argument. The function takes up to four numbers, or a single string in "A1 notation".

Source:

.getRange(row, column, numRows, numColumns)

Recommended fix:

var buildRange = [4,1, LastRow_WithValue - 4, LastColumn_WithValue - 1];
var range = sheet.getRange(...buildRange);

Additionally, here's a consolidated version:

function sortProductionLog() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME)
  sheet.getRange(4, 1, sheet.getLastRow()-4, sheet.getLastColumn()-1)
       .sort(SORT_ORDER)
}

回复收藏 0 原文

伏妖词 2025-02-02 20:55:41

这样尝试：

function sortProductionLog() {
  const ss = SpreadsheetApp.getActive()
  var sh = ss.getSheetByName("SHEET_NAME");
  var range = sh.getRange(4, 2, sh.getLastRow() - 3, sh.getLastColumn());
  ss.toast(range.getA1Notation());
  range.sort([{ column: 118, ascending: true }, { column: 119, ascending: true }, { column: 117, ascending: true }, { column: 25, ascending: true }]);
}

Try it this way:

function sortProductionLog() {
  const ss = SpreadsheetApp.getActive()
  var sh = ss.getSheetByName("SHEET_NAME");
  var range = sh.getRange(4, 2, sh.getLastRow() - 3, sh.getLastColumn());
  ss.toast(range.getA1Notation());
  range.sort([{ column: 118, ascending: true }, { column: 119, ascending: true }, { column: 117, ascending: true }, { column: 25, ascending: true }]);
}

回复收藏 0 原文

~没有更多了~