private Stopwatch wath = new Stopwatch();        /// 
        /// 使用COM读取Excel        /// 
        /// 路径        /// 
     
      DataTabel
             public System.Data.DataTable GetExcelData(string excelFilePath)        {            Excel.Application app = new Excel.Application();            Excel.Sheets sheets;            Excel.Workbook workbook = null;            object oMissiong = System.Reflection.Missing.Value;            System.Data.DataTable dt = new System.Data.DataTable();            wath.Start();            try            {                if (app == null)                {                    return null;                }                workbook = app.Workbooks.Open(excelFilePath, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong);                //将数据读入到DataTable中——Start                   sheets = workbook.Worksheets;                Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);//读取第一张表                if (worksheet == null)                    return null;                string cellContent;                int iRowCount = worksheet.UsedRange.Rows.Count;                int iColCount = worksheet.UsedRange.Columns.Count;                Excel.Range range;                //负责列头Start                DataColumn dc;                int ColumnID = 1;                range = (Excel.Range)worksheet.Cells[1, 1];                while (range.Text.ToString().Trim() != "")                {                    dc = new DataColumn();                    dc.DataType = System.Type.GetType("System.String");                    dc.ColumnName = range.Text.ToString().Trim();                    dt.Columns.Add(dc);                    range = (Excel.Range)worksheet.Cells[1, ++ColumnID];                }                //End                for (int iRow = 2; iRow <= iRowCount; iRow++)                {                    DataRow dr = dt.NewRow();                    for (int iCol = 1; iCol <= iColCount; iCol++)                    {                        range = (Excel.Range)worksheet.Cells[iRow, iCol];                        cellContent = (range.Value2 == null) ? "" : range.Text.ToString();                        //if (iRow == 1)                        //{                        //    dt.Columns.Add(cellContent);                        //}                        //else                        //{
                            dr[iCol - 1] = cellContent;                        //}                    }                    //if (iRow != 1)                    dt.Rows.Add(dr);                }                wath.Stop();                TimeSpan ts = wath.Elapsed;                //将数据读入到DataTable中——End                return dt;            }            catch            {                return null;            }            finally            {                workbook.Close(false, oMissiong, oMissiong);                System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);                workbook = null;                app.Workbooks.Close();                app.Quit();                System.Runtime.InteropServices.Marshal.ReleaseComObject(app);                app = null;                GC.Collect();                GC.WaitForPendingFinalizers();            }        }

使用COM组件读取EXCEL    该方法读取到的EXCEL第一行讲做为表头。