dev winform导出功能

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

 SaveFileDialog fileDialog = new SaveFileDialog();

             fileDialog.Title = "导出Excel";

             fileDialog.Filter = "Excel文件(*.xls)|*.xls";

             DialogResult dialogResult = fileDialog.ShowDialog(this);

             if (dialogResult == DialogResult.OK)

             {

                 try

                 {

                     DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();

                     gridControl1.ExportToXls(fileDialog.FileName);

                     DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                 }

                 catch (Exception ex)

                 {

                     if (ex.Message.Contains("正由另一进程使用"))

                     {

                         DevExpress.XtraEditors.XtraMessageBox.Show("数据导出失败！文件正由另一个程序占用！", "提示");

                     }

                     else

                         DevExpress.XtraEditors.XtraMessageBox.Show("数据导出失败！数据量过大，请分别统计再导出！", "提示");

                 }

             }