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 vote262 views1 answer
Golang get file sha256
Go
0 vote210 views1 answer
Golang write excel
Go
0 vote272 views1 answer
Raise number to power golang
Go
0 vote255 views1 answer
:= in golang
Go
0 vote261 views1 answer
Match cell with the value google sheets
Go
3 votes249 views2 answers
Golang convert string to float
Go
0 vote230 views1 answer
Golang type enum
Go
213 votes338 views6 answers
Gamestop stocks
Go
16 votes334 views6 answers
Never gonna give you up release date
Go
0 vote236 views3 answers
`Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Post http://%2Fvar%2Frun%2Fdocker.sock/v1.24/images/create?fromImage=mysql&tag=latest: dial unix /var/run/docker.sock: connect: permission
Go