111,094
社区成员




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);