public DataTable GetDataFromExcel(string p_Path)

 {

 string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + p_Path + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=0'";

    OleDbConnection conExcel = new OleDbConnection(strCon);

    DataSet ds = new DataSet();

    DataTable dt = new DataTable();

    try

    {

      if (!File.Exists(p_Path))

      {

         dt.TableName = "false";

       }

       else

       {

         conExcel.Open();

         string strSql = "select * from  [Sheet1$A:CV] where [银行账号] is not null and [银行账号] <> ''";

       //  string strSql = "select * from  [Sheet1$] where [银行账号] is not null and [银行账号] <> ''";

         OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(strSql, conExcel);

         int i = myDataAdapter.SelectCommand.Parameters.Count;

         System.Data.OleDb.OleDbCommandBuilder builder = new OleDbCommandBuilder(myDataAdapter);

         builder.QuotePrefix = "[";     //获取insert语句中保留字符（起始位置）

         builder.QuoteSuffix = "]"; //获取insert语句中保留字符（结束位置）

         myDataAdapter.Fill(ds, "Sheet1$");//这个地方会报错“定义了过多的字段”

         dt = ds.Tables[0].Copy();

         conExcel.Close();

          ds.WriteXml("c:\\EXML.xml"); //Excel To XML

          }

        }

       catch (Exception e)

        {

         if (conExcel.State == ConnectionState.Open)

         conExcel.Close();

         log4net.LogManager.GetLogger(this.GetType()).Error("GetDataFromExcel(" + p_Path + ")", e);

         dt.TableName = "false";

         }

        File.Delete(p_Path);//删除文件

         return dt;

}