vsto 判断sheet是否存在

//如果为null就是没有
public static class WorkbookExtensions
{
    public static Excel.Worksheet GetWorksheetByName(this Excel.Workbook workbook, string name)
    {
        return workbook.Worksheets.OfType<Excel.Worksheet>().FirstOrDefault(ws => ws.Name == name);
    }
}


//查询名称管理器
Excel.Name name = activeWorkbook.Names.OfType<Excel.Name>().FirstOrDefault(ws => ws.Name == inputName);



Excel.Name name = worksheet.Names.OfType<Excel.Name>().FirstOrDefault(ws => ws.Name == inputName);