C#使用Ado.net读取Excel表的方法

using System;using System.Data.OleDb;namespace ConsoleApplication1{ class Program { static void Main() {  string connString = "Provider=Microsoft.Jet.OleDb.4.0; data source=c://sample.xls; Extended Properties=Excel 8.0;";  // Select using a Worksheet name  string selectqry = "SELECT * FROM [Sheet1$]";  OleDbConnection conn = new OleDbConnection(connString);  OleDbCommand cmd = new OleDbCommand(selectqry,con);  try  {  con.Open();  OleDbDataReader theDatardr = cmd.ExecuteReader();  while (theDatardr.Read())  {   Console.WriteLine("{0}:{1}({2}){3}({4})",theDatardr.GetString(0),theDatardr.GetString(1),theDatardr.GetString(2),theDatardr.GetString(3),theDatardr.GetString(4));  }  }  catch (Exception ex)  {  Console.WriteLine(ex.Message);  }  finally  {  con.Dispose();  } } }}