private void Export()
{
//GridControl
if (gcField != null)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.FileName = this.Text;
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsExportOptionsEx options = new DevExpress.XtraPrinting.XlsExportOptionsEx();
options.ShowGridLines = true;
options.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
options.ExportType = DevExpress.Export.ExportType.WYSIWYG;
//自带的导出功能
gcField.ExportToXls(saveFileDialog.FileName, options);
//打开
DialogResult result = XtraMessageBox.Show("确定打开吗?", "导出", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
else
{
DevExpress.XtraEditors.XtraMessageBox.Show("没有选择数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
代码图片如下:
二:导出的是Xlsx格式
if (gridControl1 != null)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel";
saveFileDialog.FileName = this.Text;
//saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx";
DialogResult dialogResult = saveFileDialog.ShowDialog(this);
if (dialogResult == DialogResult.OK)
{
DevExpress.XtraPrinting.XlsxExportOptionsEx options = new DevExpress.XtraPrinting.XlsxExportOptionsEx();
options.ShowGridLines = true;
//如果导出的类型数据出错可以用这个替换下面那句options.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text;
options.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Value;
options.ExportType = DevExpress.Export.ExportType.WYSIWYG;
//自带的导出功能
gridControl1.ExportToXlsx(saveFileDialog.FileName, options);
//打开
DialogResult result = XtraMessageBox.Show("确定打开吗?", "导出", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
else
{
DevExpress.XtraEditors.XtraMessageBox.Show("没有选择数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
如果要设置导出的格式,可以在下图设置值
加上这个会好看点