Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?

by

Found these docu on the google docu pages:

  • row — int — top row of the range
  • column — int— leftmost column of the range
  • optNumRows — int — number of rows in the range.
  • optNumColumns — int — number of columns in the range

In your example, you would get (if you picked the 3rd row) “C3:O3”, cause C –> O is 12 columns

edit

Using the example on the docu:

// The code below will get the number of columns for the range C2:G8

// in the active spreadsheet, which happens to be “4”

var count = SpreadsheetApp.getActiveSheet().getRange(2, 3, 6, 4).getNumColumns();
Browser.msgBox(count);

The values between brackets:

2: the starting row = 2

3: the starting col = C

6: the number of rows = 6 so from 2 to 8

4: the number of cols = 4 so from C to G

So you come to the range: C2:G8

More Related Contents:

  1. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  2. Moving google apps script to v8 file upload stopped working from sidebar
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. How do I make a Sidebar display values from cells?
  5. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  6. button click is only working on Windows & not working on Android mobile sheet
  7. No permission to call msgBox in Google Apps Scripting
  8. Custom functions intermittently hang with “Error – Loading Data”
  9. How to define global variable in Google Apps Script
  10. Periodically refresh IMPORTXML() spreadsheet function
  11. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  12. How do I add formulas to Google Sheets using Google Apps Script?
  13. Deleting rows in google sheets using Google Apps Script
  14. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  15. Adding Buttons To Google Sheets and Set value to Cells on clicking
  16. Google apps script to email google spreadsheet excel version [duplicate]
  17. Export Single Sheet to PDF in Apps Script
  18. Custom function throws a “You do not have the permission required to setValue” error
  19. Margins parameters for Google spreadsheet export as PDF
  20. Script to convert .XLSX to Google Sheet and move converted file
  21. Hidden field in a Google Form
  22. Measurement of execution time of built-in functions for Spreadsheet
  23. onEdit() doesn’t catch all changes
  24. Google Spreadheets Scripts: check if cell is empty
  25. Custom Functions with add-ons?
  26. How to prefill Google form checkboxes?
  27. Converting .xls to google spreadsheet in google apps script
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment