C#操作EXCEL之用OleDb快速讀取資料到DataTable

1,說明:
Excel的Sheet名稱必須已知, 且表中第一行必須為欄位名

2,程式樣本:

using System.Data;
using System.Data.OleDb;

namespace TEST
{

public class _TEST
{
    private OleDbConnection m_XLSConn;
        private OleDbDataAdapter m_XLSAdapter;

        private DataTable GetDataFromXLS(string s_FileName)
        {
            string s_ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + s_FileName + ";Extended Properties = Excel 8.0";
            string s_SQLSelect = "select * from [Sheet1$]";
            m_XLSConn = new OleDbConnection(s_ConnString);
            m_XLSAdapter = new OleDbDataAdapter(s_SQLSelect, m_XLSConn);
            DataTable m_dtXLS = null;
            try
            {
                m_dtXLS = DataTable();
                m_XLSConn.Open();
                m_XLSAdapter.Fill(m_dtXLS);
            }
            catch (Exception exc)
            {
                throw exc;
            }
            finally
            {
                if (m_XLSConn.State == ConnectionState.Open)
                    m_XLSConn.Close();
            }

            return m_dtXLS;
        }
}

}