62,046
社区成员
发帖
与我相关
我的任务
分享
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter oleDbDataAdapter = null;
DataSet ds = new DataSet();
string strExcel = "select * from [sheet1$]";
oleDbDataAdapter = new OleDbDataAdapter(strExcel, conn);
oleDbDataAdapter.Fill(ds, "Data");
conn.Close();