读取Excel和CSV文件数据

Excel：

string fileNameString = this.MapPath(".");
   fileNameString += "..\\..\\..\\..\\data\\ExcelData.xls";

   // Create connection object by using the preceding connection string.
   string sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
    fileNameString + ";Extended Properties=\"Excel 8.0;HDR=YES\"";
   OleDbConnection myConnection = new OleDbConnection( sConn );
   myConnection.Open();

   // The code to follow uses a SQL SELECT command to display the data from the worksheet.
   // Create new OleDbCommand to return data from worksheet.
   OleDbCommand myCommand = new OleDbCommand( "Select * From [data1$A1:E25]", myConnection );

   // create a database reader 
   OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

 

CSV：

// Create a select statement and a connection string.
     string mySelectQuery = "Select * from "+ file;
     string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+
      path+ ";Extended Properties=\"Text;HDR=No;FMT=Delimited\"";
     
     OleDbConnection myConnection = new OleDbConnection(ConStr);

     // create a database command on the connection using query
     OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);

     // open the connection
     myCommand.Connection.Open();
     // create a database reader
     OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);