Asp.net C# 遍历Excel中的表格名称

最新推荐文章于 2022-12-24 21:15:18 发布

weixin_30216561

最新推荐文章于 2022-12-24 21:15:18 发布

阅读量160

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/wolfocme110/p/3900704.html

版权

Asp.net C# 遍历Excel中的表格名称

   string strConn = " Provider=Microsoft.Jet.OLEDB.4.0; " + " Data Source= " + filePath + " ; " + " Extended Properties=\"Excel 8.0\" ";
     // string strConn_ACE = "Provider=Microsoft.ACE.OLEDB.12.0;data source=" + filePath + ";Extended Properties='Excel 12.0;HDR=NO;IMEX=1'";
     // new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("DataBase/hooyesDatabase.mdb"));

    OleDbConnection conn = new OleDbConnection(strConn);
    conn.Open();

    DataSet ds = new DataSet();
    OleDbDataAdapter da = null;
    DataTable dtSheetName = null;

     string SheetName = "";
    dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, " TABLE " });

     for ( int i = 0; i < dtSheetName.Rows.Count; i++)
    {
        SheetName = ( string)dtSheetName.Rows[i][ " TABLE_NAME "];

         if (SheetName.Contains( " $ ") && !SheetName.Replace( " ' ", "").EndsWith( " $ "))
        {
             continue;
        }
         if (SheetName == " 已售号码$ ")
        {
             break;
        }

    }

转载于:https://www.cnblogs.com/wolfocme110/p/3900704.html