google excel script - 指令碼編輯器

開始

程式碼

var ss = SpreadsheetApp.getActiveSpreadsheet(); // get 現在這個 google spread sheet

// The onOpenfunction create a menu
function onOpen(){
var menuEntries = [];
menuEntries.push({name: "SetColor", functionName: "function1"});
menuEntries.push(null); // line separator
menuEntries.push({name: "Another", functionName: "function2"});
menuEntries.push(null); // line separator
ss.addMenu("addMenuExample", menuEntries);
}

• 再來就是你所要做的功能，變色

var colorRef1 = ss.getRange('A1').getBackgroundColor(); //the color reference you put at A1 location
function function1(){
var range = ss.getActiveRange(); // get range you selected
range.setBackground(colorRef1); // the color reference
range.setBorder(true, true, true, true, false, false);//setBorder(top, left, bottom, right, vertical, horizontal)
console.log(range.getA1Notation());
}

補充

var ss = SpreadsheetApp.getActiveSpreadsheet(); // get 現在這個 google spread sheet
var sheet1 = ss.getSheetByName("測試"); // "測試" 為你的工作表分頁名稱，注意不是左上角的名稱

console.log(你要 debug 的變數);

執行