C# 读取Excel文件

public static string connStr
        {
            get 
{
return
"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';data source=C:\\AP COLLECT 08.xls";
}
        }
+++++++++
使用以上字符串连接Excel文件

OleDbConnection conn = new OleDbConnection(LinkClass.connStr);
            OleDbCommand com = new OleDbCommand("select * from [ML$]", conn);

+++++++++

using System;
using System.Collections.Generic;
using System.Text;

namespace CTracking
{
    class LinkClass
    {
        /// <summary>
        /// Excel保存的位置
        /// </summary>
        public static string excel_posi
        {
            get { return "data source=C:\\AP COLLECT 08.xls"; }
        }
        /// <summary>
        /// 链接字符串
        /// </summary>
        public static string connStr
        {
            get { return "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';" + excel_posi; }
        }
        //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

        /// <summary>
        /// Oracle 连接字符串
        /// </summary>
        public static string oracle_conn_str
        {
            //get { return "Data Source=ora_10.201.176.30;Persist Security Info=True;User ID=EMS_WGQ;Password=emssme;Unicode=True"; }
            get { return "Data Source=orapw;Persist Security Info=True;User ID=EMS_WGQ;Password=emssme;Unicode=True"; }
        }
    }
}

++++++++++++++++++
Excel就像数据库,每个Sheet就是一个Table. Microsoft.Jet.OLEDB驱动.之后是DataReader循环,或DataSet处理
++++++++++++++++++