读Excel代码如下:ds=new DataSet();
OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="c:/zhuhui.xls";"+
"Extended Properties=\"Excel 8.0;\"");
conn.Open();
OleDbCommand myCommand=new OleDbCommand("select * from [Sheet1$]",conn);
OleDbDataAdapter myAdapter=new OleDbDataAdapter(myCommand);
myAdapter.Fill(ds);
conn.Close();
OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="c:/zhuhui.xls";"+
"Extended Properties=\"Excel 8.0;\"");
conn.Open();
OleDbCommand myCommand=new OleDbCommand("select * from [Sheet1$]",conn);
OleDbDataAdapter myAdapter=new OleDbDataAdapter(myCommand);
myAdapter.Fill(ds);
conn.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货