C#关于Excel表的连接支持及操作

   

        string fileName = "xxx.xlsx";//这里是你xlsx或者xls的文件名字
        string strConn= "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";

//Microsoft.ACE.OLEDB.12.0是新版，旧版为Provider = Microsoft.Jet.OLEDB.4.0;

//你需要把Excel表放到项目里面，并在表属性“复制到输出目录”里改为“如果较新则复制”

    OleDbConnection conn = new OleDbConnection(strConn);

    conn.Open();
    string sql = "select * from [Sheet1$]";
    OleDbDataAdapter adapter = new OleDbDataAdapter(sql,conn);

    DataSet dataSet=new DataSet();//用来存放DataTable
    adapter.Fill(dataSet);

    conn.Close();//释放连接资源

    DataTableCollection tableCollection=dataSet.Tables;

    DataTable table = tableCollection[0];

    DataRowCollection rowCollection=table.Rows;

    //遍历行的集合
    foreach(DataRow row in rowCollection)
    {
        for(int i = 0; i < 4; i++)//可以输入你想查询的列数
        {
            Console.Write(row[i] + " ");
        }
        Console.WriteLine();
    }
    Console.ReadKey();
}