• Devexpress GridControl.Export 导出


    private void mnuExportTable_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
    {
    using (SaveFileDialog saveDialog = new SaveFileDialog())
    {
    saveDialog.Filter = "Excel (2003)(.xls)|*.xls|Excel (2010) (.xlsx)|*.xlsx |RichText File (.rtf)|*.rtf |Pdf File (.pdf)|*.pdf |Html File (.html)|*.html";
    if (saveDialog.ShowDialog() != DialogResult.Cancel)
    {
    string exportFilePath = saveDialog.FileName;
    string fileExtenstion = new FileInfo(exportFilePath).Extension;

    switch (fileExtenstion)
    {
    case ".xls":
    gridControl.ExportToXls(exportFilePath);
    break;
    case ".xlsx":
    gridControl.ExportToXlsx(exportFilePath);
    break;
    case ".rtf":
    gridControl.ExportToRtf(exportFilePath);
    break;
    case ".pdf":
    gridControl.ExportToPdf(exportFilePath);
    break;
    case ".html":
    gridControl.ExportToHtml(exportFilePath);
    break;
    case ".mht":
    gridControl.ExportToMht(exportFilePath);
    break;
    default:
    break;
    }

    if (File.Exists(exportFilePath))
    {
    try
    {
    //Try to open the file and let windows decide how to open it.
    System.Diagnostics.Process.Start(exportFilePath);
    }
    catch
    {
    String msg = "The file could not be opened." + Environment.NewLine + Environment.NewLine + "Path: " + exportFilePath;
    MessageBox.Show(msg, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
    }
    else
    {
    String msg = "The file could not be saved." + Environment.NewLine + Environment.NewLine + "Path: " + exportFilePath;
    MessageBox.Show(msg, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
    }
    }
    }

  • 相关阅读:
    J2SE基础:7.系统经常使用类一
    Win7 64位 php-5.5.13+Apache 2.4.9+mysql-5.6.19 配置
    FUDCon
    扬帆起航 彼岸花开——2013届毕业晚会《再见民大》倾情再演
    毛磊
    查经
    H.O.T candy
    svn rm --keep-local ./QueryParser_kill.logs
    python datetime笔记
    柯震东_百度百科
  • 原文地址:https://www.cnblogs.com/ljy0905/p/4727413.html
Copyright © 2020-2023  润新知