string path = Server.MapPath("~/储存表格\\" + c);
FileUpload1.PostedFile.SaveAs(path);
string clientFilename = FileUpload1.PostedFile.FileName.ToLower();
Response.Write(clientFilename);
OleDbConnection conn = null;
string connectString2003 = string.Format("provider = microsoft.jet.oledb.4.0;data source={0};Extended Properties='Excel 8.0;HDR=No;IMEX=1'", path);
string connectString2007 = string.Format("provider = microsoft.ace.oledb.12.0;data source={0};Extended Properties='Excel 12.0;HDR=No;IMEX=1'", path);
if (path.ToLower().Contains(".xlsx"))
conn = new OleDbConnection(connectString2007);
else
conn = new OleDbConnection(connectString2003);
OleDbDataAdapter ada = new OleDbDataAdapter("select * from [Sheet1$]", conn);
DataSet ds = new DataSet();
ada.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
读取07.xlsx提示未在本地计算机上注册“microsoft.ace.oledb.12.0”提供程序!即使不按照office也能读取excel表格的方法,我不要安装什么其他东西的解决方法,其他读取excel也行
FileUpload1.PostedFile.SaveAs(path);
string clientFilename = FileUpload1.PostedFile.FileName.ToLower();
Response.Write(clientFilename);
OleDbConnection conn = null;
string connectString2003 = string.Format("provider = microsoft.jet.oledb.4.0;data source={0};Extended Properties='Excel 8.0;HDR=No;IMEX=1'", path);
string connectString2007 = string.Format("provider = microsoft.ace.oledb.12.0;data source={0};Extended Properties='Excel 12.0;HDR=No;IMEX=1'", path);
if (path.ToLower().Contains(".xlsx"))
conn = new OleDbConnection(connectString2007);
else
conn = new OleDbConnection(connectString2003);
OleDbDataAdapter ada = new OleDbDataAdapter("select * from [Sheet1$]", conn);
DataSet ds = new DataSet();
ada.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
读取07.xlsx提示未在本地计算机上注册“microsoft.ace.oledb.12.0”提供程序!即使不按照office也能读取excel表格的方法,我不要安装什么其他东西的解决方法,其他读取excel也行