//构造ole对象,打开aaa.xsl
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=aaa.xls;Extended Properties=Excel 8.0;");
myConn.Open();
//读取sheet1
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM [Sheet1$]",myConn);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,"ExcelInfo");
这样访问excel就可以了,无须客户端是否安装excel
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=aaa.xls;Extended Properties=Excel 8.0;");
myConn.Open();
//读取sheet1
OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM [Sheet1$]",myConn);
DataSet thisDataSet=new DataSet();
thisAdapter.Fill(thisDataSet,"ExcelInfo");
这样访问excel就可以了,无须客户端是否安装excel
然后用tlbimp来生成excel.dll wish u good luck
Greatsft