code.gs
程式碼
程式碼
function doGet() {
return HtmlService.createHtmlOutputFromFile("default");
}
function getHtmlPage(html) {
var htmlContent = HtmlService.createTemplateFromFile(html).getRawContent();
return htmlContent;
}
// 加入自訂選單(方便打開側邊欄)
function onOpen() {
SpreadsheetApp.getUi()
.createMenu('自訂功能')
.addItem('顯示課務處理單功能面板', 'showSidebar')
.addItem('顯示兼代課功能面板', 'showSidebar1')
.addItem('顯示輔導課功能面板', 'showSidebar2')
.addToUi();
}
function goToSheet(sheetName) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(sheetName);
if (sheet) {
ss.setActiveSheet(sheet);
} else {
SpreadsheetApp.getActiveSpreadsheet().toast("找不到工作表:" + sheetName);
}
}
function selectPrintArea() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A1:L17').activate();
};