Cannot find method getRange(number,number)?

by

Issue:

  • getRange is a method that’s available both on Spreadsheet class and Sheet class.

  • However, only getRange(string) is available on Spreadsheet(ss). So, you can use ss.getRange('Sheet1!A1:B4').

  • And getRange(number,number) is only available on sheet. So, You can use ss.getActiveSheet().getRange(1,4).

  • Sheet class also accepts other variations of this method, but Spreadsheet class doesn’t, which only accepts string as the only parameter.

  • Sometimes, You also receive

    Exception: The parameters (String,number,number,number) don’t match the method signature for SpreadsheetApp.Spreadsheet.getRange

    The reason the first parameter is a string is because there is a attempt by JavaScript engine to match the actual function call signature: getRange(string). It converts the first number to string, but it doesn’t know what to do with the rest of the parameters(numbers). As there is no method signature that match the call (string, number,number,number) on Spreadsheet class, it throws a error.

Solution:

Use proper methods on the intended class as described in the official documentation. For most purposes, You must use the Sheet class.

SpreadsheetApp.getActive().getSheets()[0].getRange(1,1)

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  3. How do I make a Sidebar display values from cells?
  4. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  5. button click is only working on Windows & not working on Android mobile sheet
  6. No permission to call msgBox in Google Apps Scripting
  7. Custom functions intermittently hang with “Error – Loading Data”
  8. How to define global variable in Google Apps Script
  9. Periodically refresh IMPORTXML() spreadsheet function
  10. How do I add formulas to Google Sheets using Google Apps Script?
  11. Deleting rows in google sheets using Google Apps Script
  12. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  13. Google apps script to email google spreadsheet excel version [duplicate]
  14. Margins parameters for Google spreadsheet export as PDF
  15. Script to convert .XLSX to Google Sheet and move converted file
  16. Hidden field in a Google Form
  17. Measurement of execution time of built-in functions for Spreadsheet
  18. onEdit() doesn’t catch all changes
  19. Google Spreadheets Scripts: check if cell is empty
  20. Custom Functions with add-ons?
  21. How to prefill Google form checkboxes?
  22. Converting .xls to google spreadsheet in google apps script
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment