C# 获取xlsx表名

最新推荐文章于 2024-06-21 09:27:55 发布

woshidaniu

最新推荐文章于 2024-06-21 09:27:55 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： .net c# 文章标签： .net

本文链接：https://blog.youkuaiyun.com/woshidaniu/article/details/17199985

c# 同时被 2 个专栏收录

12 篇文章

订阅专栏

.net

4 篇文章

订阅专栏

   protected void Button1_Click(object sender, EventArgs e)
    {
        string strConnection1 = "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;Data Source=";

        string strPath = Server.MapPath("file") + "\\" + FileUpload1.FileName;
        FileUpload1.SaveAs(Server.MapPath("file") + "\\" + FileUpload1.FileName);
        OleDbConnection con = new OleDbConnection(strConnection1+strPath);
        Response.Write(strConnection1);
        con.Open();
        try
        {
            DataTable schema = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            //下面取得第一个表名
            string strTableName = schema.Rows[0]["TABLE_NAME"].ToString();

            Response.Write(strTableName);

            OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + strTableName + "]", con);
            DataSet ds = new DataSet();
            da.Fill(ds);

            da.Dispose();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            con.Close();
        }
    }