6,107
社区成员




string xlsPath = Server.MapPath(@"~/App_Data/Book1.xls");
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + xlsPath + ";Extended Properties='Excel 11.0;HDR=Yes;IMEX=1;'";
string sql = "SELECT * FROM [Sheet1$]";
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
da.Fill(ds);