如果你试图在一个不存在的列上使用getColumnByName（例如，因为它已经被删除），你会得到一个错误。如果你在文件中有多个表，并且workbook.getTables()[0]返回了错误的表，你也会得到这个错误。
出于我的目的，我假设代码抛出错误是因为代码之前已经运行过，而不是因为引用了错误的表。如果这不正确，请告诉我，我可以调整代码。您可以看到下面的代码：

function main(workbook: ExcelScript.Workbook) {
      let selectedSheet = workbook.getActiveWorksheet();
    
      let table = workbook.getTables()[0];
    
      //delete a column with a header named "Object Type"
    
      //added optional chaining so that this line doesn't throw
      //an error if the column has previously been deleted
      table.getColumnByName("Object_Type")?.delete()
    
      //shows the total row for the table
      table.setShowTotals(true)
    
      //sets the rangeHits variable to the rangeHits column in the table
      let rangeHits = table.getColumnByName("Hits");
    
    //Sum up the cells  (all the visible filtered cells) in the column named "Hits"
      rangeHits.getTotalRowRange().setFormulaLocal(`=SUBTOTAL(109,${rangeHits.getRangeBetweenHeaderAndTotal().getAddress()}`)
    }