Dev控件学习-GridControl中的BandGridview导出多层行头操作

 1  public static void ExportExcel2(DevExpress.XtraGrid.Views.BandedGrid.BandedGridView bandedGridView)
 2         {
 3             SaveFileDialog saveFileDialog = new SaveFileDialog();
 4             saveFileDialog.Title = "导出Excel";
 5             saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
 6             DialogResult dialogResult = saveFileDialog.ShowDialog();
 7             if (dialogResult == DialogResult.OK)
 8             {
 9                 DevExpress.XtraPrinting.XlsxExportOptionsEx op = new DevExpress.XtraPrinting.XlsxExportOptionsEx();
10                 
11                 op.ExportType = DevExpress.Export.ExportType.WYSIWYG;
12                 bandedGridView.OptionsPrint.PrintHeader = false;
13                 bandedGridView.OptionsPrint.AutoWidth = false;
14                 bandedGridView.ExportToXlsx(saveFileDialog.FileName, op);
15                 DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
16             }  
17         }