本身有用開 spreadsheet,
我想做個 function 鍵做表格,
範圍係由 A3:J3, 我知道選取範圍係打 Spreadsheet.getRange(A3:J3).active()
但呢個動作有時係會換行, 因為 A1:J3 已經用咗嘛
咁下次我會由 A5:J8, 總括就係每次個範圍都唔同,
但起始就定咗係 A 同 J 之間
條 code 應該點寫
有冇巴打幫手教教
function main() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var CurrentSheet = spreadsheet.getSheets()[0];
var StartRow = 2
var EndRow = 10
var StartColumn = 1
var EndColumn = 10
var range = CurrentSheet.getRange(StartRow, StartColumn, EndRow-StartRow+1, EndColumn-StartColumn+1);
range.setBorder(true, true, true, true, true, true, '#000000', SpreadsheetApp.BorderStyle.SOLID);
return
}
function test() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var CurrentSheet = spreadsheet.getSheets()[0];
var StartRow = 3
var EndRow = 8
var StartColumn = 2
var EndColumn = 9
var Count = 1;
for (var i = StartRow;i<=EndRow;i++) {
for (var j = StartColumn;j<=EndColumn;j++) {
var cells = CurrentSheet.getRange(i, j);
cells.setValue(Count);
Count += 1;
}
}
return
}