Answers for "google script get range"

Go
0

google sheets get ranges

//getRange(row, column, optNumRows, optNumColumns);
Sheet.getRange(1,1,1,12);

//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
Posted by: Guest on July-29-2020
0

getranges google script

let SS = APP.getActiveSpreadsheet();
let sheetIndex0 = SS.getSheets()[0];

sheetIndex0.getRangeList(['A1', 'B1:C7']).setHorizontalAlignment("center");
Posted by: Guest on November-01-2020
-1

.setRowHeights google script

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

// Sets the first three rows to a height of 20 pixels
sheet.setRowHeights(1, 3, 20);
Posted by: Guest on November-01-2020

Code answers related to "google script get range"

Browse Popular Code Answers by Language