Setborder google script

SetValues()

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

// The size of the two-dimensional array must match the size of the range.
var values = [
  [ "2.000", "1,000,000", "$2.99" ]
];

var range = sheet.getRange("A1:C1");
range.setValues(values);

Setborder google script

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

var cell = sheet.getRange("B2");
// Sets borders on the top and bottom, but leaves the left and right unchanged
// Also sets the color to "red", and the border to "DASHED".
cell.setBorder(true, null, true, null, false, false, "red", SpreadsheetApp.BorderStyle.DASHED);
//.setBorder(top, left, bottom, right, vertical, horizontal, color, style)

Similar codes

0 vote162 views1 answer
Create json in go
Go
0 vote135 views1 answer
Salutem ex gonsas
Go
1 vote127 views1 answer
Go constant
Go
7 votes132 views2 answers
What is go
Go
0 vote140 views1 answer
ValueError: numpy.ufunc size changed, may indicate binary incompatibility. Expected 216 from C header, got 192 from PyObject
Go
0 vote132 views1 answer
Run a go app
Go
0 vote126 views1 answer
Escape html golang
Go
0 vote132 views3 answers
Go make example
Go
0 vote127 views1 answer
Golang convert from ISO 8601 to milliseconds
Go
0 vote134 views1 answer
How to open a file in gofer
Go