代码
 if (dialogResult == DialogResult.OK)
            {
                XlsExportOptions options = new XlsExportOptions();
               // options.TextExportMode = TextExportMode.Text;
                options.SheetName = reportHeader;
                options.Suppress256ColumnsWarning = true;
                options.Suppress65536RowsWarning = true;
                options.ShowGridLines = false;
                if (gridView != null)
                {
                   gridView.OptionsPrint.AutoWidth = false;//导出时自动调整列宽
                   gridControl.ExportToXls(saveFileDialog.FileName);
                }
                else if (pivotGridControl != null)
                {
                    //pivotGridControl.OptionsPrint.AutoWidth = false;//打印时自动调整列宽
                    pivotGridControl.ExportToXls(saveFileDialog.FileName, options);                    ExportToExcle(saveFileDialog.FileName);
                }
                DevExpress.XtraEditors.XtraMessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                DialogResult openFile = MessageUtility.ShowOkCancelAndTips(@"您需要打开此文件吗?");
                if (openFile == System.Windows.Forms.DialogResult.OK)
                {
                    System.Diagnostics.Process.Start(saveFileDialog.FileName);
                }
            }