110,545
社区成员
发帖
与我相关
我的任务
分享
oleDbConnection =new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;IMEX=1;\"");
10 OleDbCommand selectCommand = new OleDbCommand();
11 selectCommand.Connection = oleDbConnection;
12 selectCommand.CommandText = "select * from $sheet1";
13 selectCommand.CommandType = CommandType.Text;
14 OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommand);
15 dataSet = new DataSet();
16 adapter.Fill(dataSet);