VB.NET——程序检查以查看是否存在Excel中的表

您可以获取工作表集合并迭代并检查名称,这是c#

foreach (Sheet xlsSheet in xlsxWorkbooks)
{
    if (xlsSheet.Name.equals("NameYouAreLookingFor")) // Maybe add ToLower() incase of case issues
    {
        //Return First Cell Value
    }
}

bool sheetExist = false;
OleDbConnection objConn = new OleDbConnection(connString);
objConn.Open();
DataTable dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
    if (dt.Rows.Count > 0)
    {
        DataRow[] rows = dt.Select("TABLE_NAME = 'Sheet1$'")
        if (rows != null)
            sheetExist = rows.count > 0
    }

var containsSheet = 
    (workBookIn.Sheets.Cast<object>()
        .Select(sheetValue => sheetValue as Worksheet))
        .Any(workbookSheet => workbookSheet != null && workbookSheet.Name == sheetName);