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

1 vote138 views1 answer
Changing scenes in godot
Go
0 vote131 views2 answers
Mongo restore collections
Go
7 votes120 views2 answers
Google colab upload a file
Go
0 vote127 views1 answer
Array of channels golang
Go
4 votes115 views1 answer
Google cloud servers
Go
0 vote133 views1 answer
Bootstrap remove placeholder on input
Go
5 votes111 views1 answer
Inline array golang
Go
3 votes125 views1 answer
How to add a logo to website logo
Go
3 votes126 views1 answer
Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.20.1:test (default-test) on project upload
Go
0 vote137 views2 answers
Golang round float to number of digits precision
Go