public static void ExportToExcel(DevExpress.XtraGrid.Views.Base.BaseView bv, string fileName) { //this.gridControl1.ExportToXlsx(fileName); try { //去除文件后缀名 string fileNameWithoutSuffix = fileName.Substring(0, fileName.LastIndexOf(".")); //后缀名 string aLastName = fileName.Substring(fileName.LastIndexOf(".") + 1, (fileName.Length - fileName.LastIndexOf(".") - 1)); //扩展名 if ((aLastName == "xls") & (!string.IsNullOrEmpty(fileName))) { bv.ExportToXls(fileName); //ExportTo(bv, new DevExpress.XtraExport.ExportXlsProvider(fileName)); } if ((aLastName == "xlsx") & !string.IsNullOrEmpty(fileName)) { bv.ExportToXlsx(fileName); // ExportTo(bv, new DevExpress.XtraExport.ExportXlsProvider(fileName)); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
/// <summary> /// Exports to ex. /// </summary> /// <param name="filename">The filename.</param> /// <param name="ext">The ext.</param> /// <param name="exportView">The export view.</param> private static void ExportToEx(String filename, string ext, DevExpress.XtraGrid.Views.Base.BaseView exportView) { Application.DoEvents(); try { Cursor currentCursor = Cursor.Current; Cursor.Current = Cursors.WaitCursor; //DevExpress.XtraPrinting.IPrintingSystem ps = DevExpress.XtraPrinting.PrintHelper.GetCurrentPS(); if (ext == "rtf") { exportView.ExportToRtf(filename); } if (ext == "pdf") { exportView.ExportToPdf(filename); } if (ext == "mht") { exportView.ExportToMht(filename); } if (ext == "htm") { exportView.ExportToHtml(filename); } if (ext == "txt") { exportView.ExportToText(filename); } if (ext == "xls") { exportView.ExportToXls(filename); } if (ext == "xlsx") { exportView.ExportToXlsx(filename); } Cursor.Current = currentCursor; } catch (Exception ex) { throw ex; } }