asp.net如何和excel连接啊?
记得以前vb是用DDE,asp.net可以吗?可以的话怎么用啊? 问题点数:50、回复次数:4Top
1 楼supercdz(烟鬼,一天两包半)回复于 2003-12-03 17:48:12 得分 0
Excel
ODBC
Standard:
"Driver={Microsoft Excel Driver
(*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"Top
2 楼supercdz(烟鬼,一天两包半)回复于 2003-12-03 17:53:18 得分 0
OLE DB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=ExcelTop
3 楼asam2183(三山)回复于 2003-12-03 18:16:29 得分 50
http://www.csdn.net/Develop/read_article.asp?id=16437Top
4 楼ylm0101()回复于 2004-01-17 14:50:38 得分 0
string strConn="Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:\\windows_error.xls;Extended Properties=\"Excel 8.0;\"";
OleDbConnection conn=new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter da=new OleDbDataAdapter("select * from [Window_error]",conn);
DataSet ds=new DataSet();
da.Fill(ds);
DataGrid1.DataSource=ds;
DataGrid1.DataBind();Top




