/// <summary>

        /// 导出到Excel

        /// </summary>

        /// <param name="gridControl">GridControl</param>

        /// <param name="fileNameTitle">导出到Excel的Sheet文件名称</param>

        public static void ExportToExcel(this GridControl gridControl, string fileNameTitle)

        {

            var fileName = SaveAs(fileNameTitle);

            XlsExportOptions options = new XlsExportOptions();

            options.Suppress256ColumnsWarning = true;

            options.Suppress65536RowsWarning = true;

            options.TextExportMode = TextExportMode.Text;

            options.SheetName = fileNameTitle;

            var gridView = (GridView)gridControl.Views[];

            gridView.AppearancePrint.Row.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;

            gridView.OptionsPrint.AutoWidth = false;

            gridView.AppearancePrint.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

            gridControl.ExportToXls(fileName, options);

            if (MessageCommon.ShowQueInf("保存成功，是否打开文件？") == DialogResult.Yes)

                System.Diagnostics.Process.Start(fileName);//打开指定路径下的文件

        }

        /// <summary>

        /// 获取用户文件保存对话框选择的完整文件路径

        /// </summary>

        /// <param name="fileNameTitle"></param>

        /// <returns></returns>

        private static string SaveAs(string fileNameTitle)

        {

            string filename = fileNameTitle + DateTime.Now.ToString("yyMMddhhmmss") + new Random().Next(, );

            return FileDialogHelper.Save("导出到 Microsoft Excel Document", "Excel文件(*.xls)|*.xls", filename, "");

        }

DevExpress.XtraGrid.Views.Grid.GridView gdv

#region GridView属性设置

//行号所在列的宽度

gdv.IndicatorWidth = ;

//顶部面板 可用于分组

gdv.OptionsView.ShowGroupPanel = false;

//显示底部面板 可用于展示统计

gdv.OptionsView.ShowFooter = true;

//奇数行的效果设置是否可用

gdv.OptionsView.EnableAppearanceEvenRow = true;

//失去焦点时 是否保留行选中效果

gdv.OptionsSelection.EnableAppearanceHideSelection = false;

//是否显示焦点单元格样式

gdv.OptionsSelection.EnableAppearanceFocusedCell = false;

//只读

gdv.OptionsBehavior.ReadOnly = true;

//不可编辑 若设置不可编辑 会导致表格中增加的按钮的单击事件不可用

gdv.OptionsBehavior.Editable = false;

//行选中

gdv.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;

//边框

//gdv.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;

//关闭列右键菜单

gdv.OptionsMenu.EnableColumnMenu = false;

//列字体对齐方式

gdv.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

//列字体设置

gdv.Appearance.HeaderPanel.Font = new System.Drawing.Font("微软雅黑", 14F, FontStyle.Bold, GraphicsUnit.Pixel);

//行字体对齐方式

gdv.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

//奇数行背景色

gdv.Appearance.EvenRow.BackColor = Color.FromArgb(, , );

//焦点行背景色

gdv.Appearance.FocusedRow.BackColor = Color.FromArgb(, , );

//焦点行字体颜色

gdv.Appearance.FocusedRow.ForeColor = Color.White;

//FooterPanel字体对齐方式

gdv.Appearance.FooterPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

//行字体

gdv.Appearance.Row.Font = new System.Drawing.Font("微软雅黑", 14F, FontStyle.Regular, GraphicsUnit.Pixel);

//导出相关设置

gdv.AppearancePrint.Row.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;

gdv.OptionsPrint.AutoWidth = false;

gdv.AppearancePrint.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

#endregion