SpreadsheetApp.getActiveSpreadSheet突然停止作業-有解無憂

起初我有我的行超出范圍的錯誤？然后，在我稍作改動后，出現“TypeError：SpreadsheetApp.getActiveSpreadSheet 不是函式”的錯誤。

我不確定為什么我的腳本不起作用。我有一個函式可以自動調整所有行的大小，另一個函式可以將我的行調整為特定數量（這個一直說我的行超出范圍）這兩個函式都用于我的行，所以我不確定是什么改變了。

function onOpen() {
    SpreadsheetApp.getUi().createMenu('Scripts')
        .addItem('Hide columns', 'hideCols')
        .addItem('Show Columns', 'show')
        .addItem('Auto Resize Rows', 'autoResizeRows')
        .addItem('Resize Rows', 'resizeRows')
        .addToUi()
}

function hideCols() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var cells = sheet.createTextFinder("Pictures").matchEntireCell(true).findAll();

  cells.map(x => sheet.hideColumns(x.getColumn()));
}

function show() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var cells = sheet.createTextFinder("Pictures").matchEntireCell(true).findAll();

  cells.map(x => sheet.showColumns(x.getColumn()));
}

function autoResizeRows() {
  var ss = SpreadsheetApp.getActiveSpreadSheet();
  var dataRange = ss.getDataRange();
  var lastRow = dataRange.getLastRow();
  ss.autoResizeRows(2, lastRow);
}

function resizeRows() {
  var sss = SpreadsheetApp.getActiveSpreadsheet();
  var cellss = sss.getSheetByName('Sheet1');
  var responseData = cellss.getDataRange().getValues();
  cellss.setRowHeights(2,responseData.length, 300);
}

固定的：

function onOpen() {
    SpreadsheetApp.getUi().createMenu('Scripts')
        .addItem('Hide columns', 'hideCols')
        .addItem('Show Columns', 'show')
        .addItem('Auto Resize Rows', 'autoResizeRows')
        .addItem('Resize Rows', 'resizeRows')
        .addToUi()
}

function hideCols() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var cells = sheet.createTextFinder("Pictures").matchEntireCell(true).findAll();

  cells.map(x => sheet.hideColumns(x.getColumn()));
}

function show() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var cells = sheet.createTextFinder("Pictures").matchEntireCell(true).findAll();

  cells.map(x => sheet.showColumns(x.getColumn()));
}

function autoResizeRows() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var ssname = ss.getActiveSheet()
  var lastRow = ssname.getDataRange().getLastRow();
  ssname.autoResizeRows(2, lastRow-2);
}
function resizeRows() {
  var sss = SpreadsheetApp.getActiveSpreadsheet();
  var cellss = sss.getSheetByName('Sheet1');
  var responseData = cellss.getDataRange().getValues();
  cellss.setRowHeights(2,responseData.length-2, 300);
}

uj5u.com熱心網友回復：

因為您在此功能中有錯字：-

function autoResizeRows() {
  var ss = SpreadsheetApp.getActiveSpreadSheet();
  var ssname = ss.getActiveSheet()
  var lastRow = ssname.getLastRow();
  ssname.autoResizeRows(1, lastRow);
}

這getActiveSpreadsheet不是getActiveSpreadSheet您的代碼破壞的原因，請將其更改S 為s.

參考：-

獲取ActiveSpreadsheet

轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/441628.html

標籤：谷歌应用脚本谷歌表格

上一篇：為每個Google作業表行創建一個檔案

下一篇：如何從單元格中獲取鏈接文本并在其他單元格中設定文本并使用GoogleApps腳本附加鏈接？