讀取excel數據

最新推荐文章于 2024-09-04 08:33:58 发布

ShulingLiu

最新推荐文章于 2024-09-04 08:33:58 发布

阅读量406

点赞数

分类专栏： c# 文章标签： excel dataset string properties sql null

本文链接：https://blog.csdn.net/ShulingLiu/article/details/6257104

版权

c# 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

string connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + vstr + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"; OleDbConnection myConnection = new OleDbConnection(connstr); myConnection.Open(); DataTable dt = myConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string tableName = dt.Rows[0][2].ToString().Trim(); string sql = "select * from [" + tableName + "]"; OleDbCommand olecomm = new OleDbCommand(sql, new OleDbConnection(connstr)); OleDbDataAdapter oleadapter = new OleDbDataAdapter(olecomm); DataSet ds = new DataSet(); oleadapter.Fill(ds, "Sheet1"); myConnection.Close();