OLEDB打开Excel文件

class clsoledb
    {
        OleDbConnection connection;
        public void OpenConnection(string xlsFils)
        {
            if (!File.Exists(xlsFils))
            {
                MessageBox.Show("文件" + xlsFils + "不存在", "提示");
                return;
            }
            string conn = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" + xlsFils + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1;'";
            connection = new OleDbConnection(conn);
            try
            {
                connection.Open();
            }
            catch (OleDbException ex)
            {
                if (ex.ErrorCode == -2147467259)
                {
                    connection.ConnectionString = "Provider = Microsoft.Ace.OLEDB.12.0;Data Source =" + xlsFils + ";Extended Properties='Excel 12.0;HDR=NO;IMEX=1;'";
                    connection.Open();
                }
            }
        }

        public DataTable Select()
        {
            DataTable dt = new DataTable();
            string Sql = "select * from [$A1:R65536]";
            OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, connection);
            mycommand.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                DataRow dr = dt.Rows[0];
                for (int col = 0; col < dt.Columns.Count; col++)
                {
                    dt.Columns[col].ColumnName = dr[col].ToString();
                }
                dt.Rows[0].Delete();
                dt.AcceptChanges();
            }
            return dt;
        }

    }