c#读取Excel文件

最新推荐文章于 2024-07-09 10:27:57 发布

原创最新推荐文章于 2024-07-09 10:27:57 发布 · 598 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#excel #c# #string #properties #sql #null

.net 专栏收录该内容

12 篇文章

订阅专栏

    private DataTable CallExcel(string filepath)
    {
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;");
        con.Open();
        DataTable schemaTable = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
        //ArrayList lis = ExcelSheetName(schemaTable);
        DataRow dr = schemaTable.Rows[0];
        //取得sheet名Rows[i][1]
        string kk = dr[2].ToString();
        kk = Convert.ToString(kk);
        string tableName = schemaTable.Rows[0][2].ToString().Trim();

        string sql = "select * from [" + kk + "]";//选择第一个数据SHEET
        OleDbDataAdapter adapter = new OleDbDataAdapter(sql, con);
        DataTable dt = new DataTable();
        adapter.Fill(dt);
        con.Close();
        con.Dispose();
        return dt;
    }