检查谷歌电子表格中是否存在工作表 [英] check for existence of a sheet in google spreadsheets

问题描述

如何检查myname工作表存在于 google 脚本中，以避免在现有名称上使用 insertSheet 时出错?

How to I check if myname sheet exist in google scripts, to avoid errors using insertSheet on an existing name?

以下无效

 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var itt = ss.getSheetByName('_EmailList');
  if (! (itt.hasNext())){
    ss.insertSheet('_EmailList');}

推荐答案

它不起作用，因为 'itt' 是没有 'hasNext()' 方法的 Sheet 类的实例.请务必在尝试编写代码之前查看文档 - 这可以保证为您节省很多麻烦 https://developers.google.com/apps-script/reference/spreadsheet/sheet

It doesn't work because 'itt' is the instance of Sheet class that doesn't have 'hasNext()' method. Please be sure to review the docs before attempting to write code - this is guaranteed to save you a lot of trouble https://developers.google.com/apps-script/reference/spreadsheet/sheet

如果指定名称的工作表不存在，getSheetByName() 将返回一个空引用.

If the sheet with the specified name doesn't exist, getSheetByName() will return a null reference.

 var itt = ss.getSheetByName('_EmailList');

 if (!itt) {

   ss.insertSheet('_EmailList');
}

这篇关于检查谷歌电子表格中是否存在工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！