代码
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);
}
}
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);
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货