?//需要連接的Excel文件地址
??????????? string excelUrl = this.Server.MapPath(@"App_data\demo.xls");
???????????
??????????? //組裝連接Excel文件的連接字符串并實例化連接
??????????? OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+excelUrl+";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=0\"");
??????????? //創(chuàng)建命令文件
??????????? OleDbCommand com = con.CreateCommand();
??????????? //查詢工作簿Sheet1
??????????? com.CommandText = "SELECT * FROM [Sheet1$]";

??????????? //實例化數(shù)據(jù)適配器
??????????? OleDbDataAdapter adpt = new OleDbDataAdapter();
??????????? adpt.SelectCommand = com;

??????????
??????????? DataSet ds = new DataSet();
??????????? //填充DataSet
??????????? adpt.Fill(ds);

??????????? //數(shù)據(jù)綁定
??????????? this.GridView1.DataSource = ds;
??????????? this.GridView1.DataBind();

總結(jié)

以上是生活随笔為你收集整理的asp.net 读取excel文件的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。