使用Google Apps脚本在Google电子表格中创建新工作表 [英] Create a new sheet in a Google Spreadsheet with Google Apps Script

问题描述

如何使用Google Apps脚本在Google电子表格中创建新工作表？

我知道这看起来很明显，但我只是想创建一个具有特定名称。

解决方案

令人惊讶的是，我没有找到任何明确和快速的答案。

所以这里是我的代码：

$ p $ function onOpen（）{
var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet（ ）;
var yourNewSheet = activeSpreadsheet.getSheetByName（您的新工作表的名称）;

if（yourNewSheet！= null）{
activeSpreadsheet.deleteSheet（yourNewSheet）;
}

yourNewSheet = activeSpreadsheet.insertSheet（）;
yourNewSheet.setName（您的新工作表的名称）;
}


最后，请注意，这张新表格将自动成为活动表格。

How to create a new sheet in a Google Spreadsheet with Google Apps Script?

I know it seems obvious but I just want to create a new sheet with a specific name.

解决方案

Surprisingly I didn't find any clear and quick answer.

So here is my code:

function onOpen() {
    var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var yourNewSheet = activeSpreadsheet.getSheetByName("Name of your new sheet");

    if (yourNewSheet != null) {
        activeSpreadsheet.deleteSheet(yourNewSheet);
    }

    yourNewSheet = activeSpreadsheet.insertSheet();
    yourNewSheet.setName("Name of your new sheet");
}

Finally, note that this new sheet will be automatically the active one.

这篇关于使用Google Apps脚本在Google电子表格中创建新工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！