Question

DevExpress GirdControl 导出EXCEL 表头样式怎么设置

Answer 1

/// <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[0];
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);//打开指定路径下的文件
}

Answer 2

Answer 3

去掉筛选就可以刻