using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace ExcelReader
{
    public class ExcelHelper
    {
        private OleDbConnection conn = new OleDbConnection();
        public ExcelHelper(string excelPath)
        {
            string connectionStr = string.Format(ConfigurationManager.AppSettings["ConnectionString"], excelPath);
            conn.ConnectionString = connectionStr;
        }
        public DataTable GetExcelTable()
        {
            OleDbCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from [Sheet1$]";
            DataTable table = new DataTable();
            OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
            oda.Fill(table);
            foreach (DataRow row in table.Rows)
            {
                if (!(row[0].ToString()).Equals("交易日期"))
                {
                    row.Delete();
                }
                else
                {
                    break;
                }
            }
            for (int i = 0; i < table.Columns.Count; i++)
            {
                table.Columns[i].ColumnName = table.Rows[0][i].ToString();
            }
            table.Rows[0].Delete();
            table = table.GetChanges(DataRowState.Unchanged);
            return table;
        }
    }
}

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=NO;IMEX=1'"/>
  </appSettings>
</configuration>