C# DevExpress GridControl匯出表格【轉】

標籤：oid   ldo   class   csdn   rtt   exce   提示   string   article   

DevExpress的GridControl提供方便的資料匯出功能，可以方便的匯出Exce,PDF,Html頁面，world形式，無需寫額外的代碼，方便、快捷。

/// <summary>        ///     匯出表格        /// </summary>        /// <param name="gridControl1"></param>        public static void DevExpressGridControlExport(GridControl gridControl1)        {            using (var saveDialog = new SaveFileDialog())            {                saveDialog.Filter = Resources.CommonFunction_DevExpressGridControlExport_Excel_97_2007檔案___xls_Excel_2010___xlsx_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) return;                var exportFilePath = saveDialog.FileName;                var fileExtenstion = new FileInfo(exportFilePath).Extension;                switch (fileExtenstion)                {                    case ".xls":                        gridControl1.ExportToXls(exportFilePath);                        break;                    case ".xlsx":                        gridControl1.ExportToXlsx(exportFilePath);                        break;                    case ".rtf":                        gridControl1.ExportToRtf(exportFilePath);                        break;                    case ".pdf":                        gridControl1.ExportToPdf(exportFilePath);                        break;                    case ".html":                        gridControl1.ExportToHtml(exportFilePath);                        break;                    case ".mht":                        gridControl1.ExportToMht(exportFilePath);                        break;                }                if (File.Exists(exportFilePath))                {                    try                    {                        if (DialogResult.Yes == MessageBox.Show(Resources.CommonFunction_DevExpressGridControlExport_, Resources.CommonFunction_DevExpressGridControlExport_提示, MessageBoxButtons.YesNo))                        {                            Process.Start(exportFilePath);                        }                    }                    catch                    {                        var msg = "The file could not be opened." + Environment.NewLine + Environment.NewLine + "Path: " + exportFilePath;                        MessageBox.Show(msg, Resources.CommonFunction_DevExpressGridControlExport_Error_, MessageBoxButtons.OK, MessageBoxIcon.Error);                    }                }                else                {                    var msg = "The file could not be saved." + Environment.NewLine + Environment.NewLine + "Path: " + exportFilePath;                    MessageBox.Show(msg, Resources.CommonFunction_DevExpressGridControlExport_Error_, MessageBoxButtons.OK, MessageBoxIcon.Error);                }            }        }

原文網址： 70212796

C# DevExpress GridControl匯出表格【轉】