function getSheetTab() {
var app = SpreadsheetApp;
var ss = app.getActiveSpreadsheet();
var activeSheet = ss.getActiveSheet();
var tabColor = activeSheet.getActiveCell().getBackground();
var sheetName = activeSheet.getActiveCell().getValue();
var newSheet = app.getActiveSpreadsheet().getSheetByName(sheetName);
newSheet.setTabColor(tabColor);
}
1 回答
是的,我确实尝试过编码,我实际上已经弄明白了 . 这就是我最终做的事情:
花了我很多时间,因为我对Google表格有点不高兴 .
谢谢!