C# 读取exl 数据不完整问题 exl数据处理

/// <summary>
        /// 读取exl文件
        /// </summary>
        /// <param name="SourceFilePath"></param>
        /// <returns></returns>
        public static DataTable GetDataTableFromExcel(string SourceFilePath)
        {
            string fileSuffix = System.IO.Path.GetExtension(SourceFilePath);

            using (DataSet ds = new DataSet())
            {
                string connString = "";

                if (fileSuffix == ".xls")//03
                {
                    connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + SourceFilePath + ";" + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
                }
                else//07
                {
                    connString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + SourceFilePath + ";" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\"";
                }
                //读取文件
                string sql_select = " SELECT * FROM [Sheet1$]";
                using (OleDbConnection conn = new OleDbConnection(connString))
                using (OleDbDataAdapter cmd = new OleDbDataAdapter(sql_select, conn))
                {
                    conn.Open();
                    cmd.Fill(ds);
                }
                if (ds == null || ds.Tables.Count <= 0) return null;
                return ds.Tables[0];
            }
        }

　　　　　//数据出路　

foreach(DataColumn column in dt.Columns)
{
//删除第一列
dt.Columns.Remove(column);
break;
}
//修改列名
foreach(DataColumn column in dt.Columns)
{
column.ColumnName=dt.Rows[0][column].ToString();
}
//删除第一列
dt.Rows.Remove(dt.Rows[0]);