/// <summary> /// 打印曲线 /// </summary> /// <param name="chart"></param> public static void chartPrint(ChartControl chart, float scalefactor) { DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); compositeLink.PrintingSystem = ps; compositeLink.PaperKind = System.Drawing.Printing.PaperKind.A4; //设置纸张 DevExpress.XtraPrinting.PrintableComponentLink link = new DevExpress.XtraPrinting.PrintableComponentLink(ps); ps.Links.Add(link); link.Component = chart; link.CreateDocument(); //建立文档 ps.PageSettings.Landscape = true; //设置为纵向 ps.PageSettings.Landscape = true; //设置为横向 //设置微缩比例 ps.Document.ScaleFactor = 1000 / scalefactor; ps.PageSettings.LeftMargin = 5; ps.PageSettings.RightMargin = 5; ps.PageSettings.TopMargin = 5; ps.PageSettings.BottomMargin = 5; ps.PreviewFormEx.Show();//进行预览 }
private void buttonExport_Click(object sender, EventArgs e) { try { SaveFileDialog SaveFileDialog1 = new SaveFileDialog(); SaveFileDialog1.Filter = "xlsx Files (*.xlsx)|*.xlsx"; SaveFileDialog1.DefaultExt = "xlsx"; if (SaveFileDialog1.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return; } ; string filepath = SaveFileDialog1.FileName; DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); compositeLink.PrintingSystem = ps; DevExpress.XtraPrinting.PrintableComponentLink link = new DevExpress.XtraPrinting.PrintableComponentLink(); link.Component = gridControl1; link.PrintingSystem = ps; compositeLink.Links.Add(link); compositeLink.CreateDocument(); compositeLink.CreatePageForEachLink(); DevExpress.XtraPrinting.XlsxExportOptions ExportOpt = new DevExpress.XtraPrinting.XlsxExportOptions(); ExportOpt.ExportMode = DevExpress.XtraPrinting.XlsxExportMode.SingleFilePageByPage; compositeLink.ExportToXlsx(filepath, ExportOpt); MessageBox.Show("导出成功!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Export_All_PivotGrid() { PivotGridControl[] grids = new PivotGridControl[] { pivotGridControl1 }; DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(ps); // Show the Document Map toolbar button and menu item. ps.SetCommandVisibility(PrintingSystemCommand.Open, CommandVisibility.All); // Make the "Export to Csv" and "Export to Txt" commands visible. ps.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls }, CommandVisibility.All); compositeLink.PrintingSystem = ps; foreach (PivotGridControl grid in grids) { PrintableComponentLink link = new PrintableComponentLink(); link.Component = grid; //compositeLink.Links.Add(link); compositeLink.Links.AddRange(new object[] { link }); } string ReportName = "Daily_Status_Report"; string folderPath = "C:\\Temp\\"; string Path1 = folderPath + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + "-" + ReportName + ".xlsx"; compositeLink.PrintingSystem.ExportToXlsx(Path1, new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage }); compositeLink.ShowPreview(); compositeLink.CreatePageForEachLink(); }
/// <summary> /// 打印GridControl /// </summary> /// <param name="control">需要被打印的GridControl</param> public static void PrintGridControl(GridControl control) { DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); compositeLink.PrintingSystem = ps; compositeLink.Landscape = true; compositeLink.PaperKind = System.Drawing.Printing.PaperKind.A4; DevExpress.XtraPrinting.PrintableComponentLink link = new DevExpress.XtraPrinting.PrintableComponentLink(ps); ps.PageSettings.Landscape = true; // PageHeaderFooter phf = compositeLink.PageHeaderFooter as PageHeaderFooter; //设置页眉 //phf.Header.Content.Clear(); //phf.Header.Content.AddRange(new string[] { "", _PrintHeader, "" }); //phf.Header.Font = new System.Drawing.Font("宋体", 14, System.Drawing.FontStyle.Bold); //phf.Header.LineAlignment = BrickAlignment.Center; //设置页脚 //phf.Footer.Content.Clear(); //phf.Footer.Content.AddRange(new string[] { "", "", "1" }); //phf.Footer.Font = new System.Drawing.Font("宋体", 9, System.Drawing.FontStyle.Regular); //phf.Footer.LineAlignment = BrickAlignment.Center; link.Component = control; compositeLink.Links.Add(link); link.CreateDocument(); //建立文档 ps.PreviewFormEx.Show(); //进行预览 }
/// <summary> /// DevExpress控件通用导出Excel,支持多个控件同时导出在同一个Sheet表或者分不同工作薄 /// eg:ExportToXlsx("test",true,"控件",gridControl1,gridControl2); /// 将gridControl1和gridControl2的数据一同导出到同一个文件不同的工作薄 /// eg:ExportToXlsx("test",false,"",gridControl1,gridControl2); /// 将gridControl1和gridControl2的数据一同导出到同一个文件同一个的工作薄 /// <param name="title">文件</param> /// <param name="isPageForEachLink">多个打印控件是否分多个工作薄显示</param> /// <param name="sheetName">工作薄名称</param> /// <param name="printables">控件集 eg:GridControl,PivotGridControl,TreeList,ChartControl...</param> public static void ExportToExcel(string FileName, bool isPageForEachLink, string sheetName, params DevExpress.XtraPrinting.IPrintable[] printables) { if (string.IsNullOrEmpty(FileName)) { return; } using (DevExpress.XtraPrintingLinks.CompositeLink link = new DevExpress.XtraPrintingLinks.CompositeLink(new DevExpress.XtraPrinting.PrintingSystem())) { foreach (var item in printables) { var plink = new DevExpress.XtraPrinting.PrintableComponentLink() { Component = item }; link.Links.Add(plink); } if (isPageForEachLink) { link.CreatePageForEachLink(); } if (string.IsNullOrEmpty(sheetName)) { sheetName = "Sheet"; } //默认工作薄名称 try { if (FileName.LastIndexOf(".xlsx") >= FileName.Length - 5) { DevExpress.XtraPrinting.XlsxExportOptions options = new DevExpress.XtraPrinting.XlsxExportOptions() { SheetName = sheetName }; if (isPageForEachLink) { options.ExportMode = DevExpress.XtraPrinting.XlsxExportMode.SingleFilePageByPage; } link.ExportToXlsx(FileName, options); } else { DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions() { SheetName = sheetName }; if (isPageForEachLink) { options.ExportMode = DevExpress.XtraPrinting.XlsExportMode.SingleFile; } link.ExportToXls(FileName, options); } } catch (Exception ex) { DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message); } } }
private void Export_Grid() { SplashScreenManager.ShowForm(this, typeof(Ordermanagement_01.Masters.WaitForm1), true, true, false); try { DevExpress.XtraPrinting.PrintingSystem ps_1 = new DevExpress.XtraPrinting.PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink compositeLink_1 = new DevExpress.XtraPrintingLinks.CompositeLink(ps_1); DevExpress.XtraPrinting.PrintableComponentLink link_1 = new DevExpress.XtraPrinting.PrintableComponentLink(); DevExpress.XtraPrinting.PrintableComponentLink link_2 = new DevExpress.XtraPrinting.PrintableComponentLink(); // Show the Document Map toolbar button and menu item. ps_1.SetCommandVisibility(PrintingSystemCommand.Open, CommandVisibility.All); // Make the "Export to Csv" and "Export to Txt" commands visible. ps_1.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls }, CommandVisibility.All); compositeLink_1.PrintingSystem = ps_1; link_1.Component = Grid_User_Summary; link_1.PaperName = "Niranjan"; link_2.Component = pivotGridControl2; compositeLink_1.Links.AddRange(new object[] { link_1, link_2 }); string ReportName = "Summary-Report"; string folderPath = "C:\\Temp\\"; string Path1 = folderPath + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + "-" + ReportName + ".xlsx"; // compositeLink.ShowPreview(); compositeLink_1.CreatePageForEachLink(); // this is for Creating excel sheet name ps_1.XlSheetCreated += PrintingSystem_XlSheetCreated_1; compositeLink_1.PrintingSystem.ExportToXlsx(Path1, new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage, ExportHyperlinks = false, TextExportMode = TextExportMode.Text }); System.Diagnostics.Process.Start(Path1); } catch (Exception ex) { //Close Wait Form SplashScreenManager.CloseForm(false); MessageBox.Show("Error Occured Please Check With Administrator"); } finally { //Close Wait Form SplashScreenManager.CloseForm(false); } }
//自定义打印 private void PrintPreview(DevExpress.XtraPrinting.IPrintable gridControlPrint) { DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); compositeLink.PrintingSystem = ps; compositeLink.Landscape = true; compositeLink.PaperKind = System.Drawing.Printing.PaperKind.A4; DevExpress.XtraPrinting.PrintableComponentLink link = new DevExpress.XtraPrinting.PrintableComponentLink(ps); ps.PageSettings.Landscape = true; link.Component = gridControlPrint; compositeLink.Links.Add(link); link.CreateDocument(); //建立文档 ps.PreviewFormEx.Show(); //进行预览 }
private void excel() { GridControl[] grids = new GridControl[] { gridControl1, gridControl2 }; PrintingSystem ps = new PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); compositeLink.PrintingSystem = ps; foreach (GridControl grid in grids) { PrintableComponentLink link = new PrintableComponentLink(); link.Component = grid; compositeLink.Links.Add(link); } compositeLink.CreateDocument(); compositeLink.ShowPreview(); }
private void Export_All_PivotGrid() { GridControl[] grids = new GridControl[] { Grd_Dash_Emp_efficency, grd_Targetorder, Grid_Error_Details }; DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(ps); // Show the Document Map toolbar button and menu item. ps.SetCommandVisibility(PrintingSystemCommand.Open, CommandVisibility.All); // Make the "Export to Csv" and "Export to Txt" commands visible. ps.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls }, CommandVisibility.All); compositeLink.PrintingSystem = ps; foreach (GridControl grid in grids) { PrintableComponentLink link = new PrintableComponentLink(); link.Component = grid; //compositeLink.Links.Add(link); compositeLink.Links.AddRange(new object[] { link }); } string ReportName = "Accuracy_Deatils"; string folderPath = "C:\\Temp\\"; string Path1 = folderPath + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + "-" + ReportName + ".xlsx"; //Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); //string myPath = @"15-02-2019-Accuracy_Deatils.xlsx"; //excelApp.Workbooks.Open(myPath); //// Get Worksheet //Microsoft.Office.Interop.Excel.Worksheet worksheet = excelApp.Worksheets[1]; //int rowIndex = 2; int colIndex = 2; //for (int i = 0; i < 10; i++) //{ // excelApp.Cells[rowIndex, colIndex] = "\r123"; //} //excelApp.Visible = false; compositeLink.PrintingSystem.ExportToXlsx(Path1, new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage }); compositeLink.ShowPreview(); compositeLink.CreatePageForEachLink(); }
private void btnPrint_Click(object sender, EventArgs e) { //this.chartControl1.ShowPrintPreview(DevExpress.XtraCharts.Printing.PrintSizeMode.Zoom); DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); compositeLink.PrintingSystem = ps; compositeLink.Landscape = true; compositeLink.PaperKind = System.Drawing.Printing.PaperKind.A4; DevExpress.XtraPrinting.PrintableComponentLink link = new DevExpress.XtraPrinting.PrintableComponentLink(ps); ps.PageSettings.Landscape = true; link.Component = this.chartControl1; compositeLink.Links.Add(link); link.CreateDocument(); //建立文档 ps.PreviewFormEx.Show(); //进行预览 }
// Export Error Desc Chart private void Export_Error_On_User() { load_Progressbar.Start_progres(); DevExpress.XtraPrinting.PrintingSystem ps2 = new DevExpress.XtraPrinting.PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink cl_2 = new DevExpress.XtraPrintingLinks.CompositeLink(ps2); DevExpress.XtraPrinting.PrintableComponentLink pclChart2 = new DevExpress.XtraPrinting.PrintableComponentLink(); chartControl3.Visible = true; pclChart2.Component = chartControl3; cl_2.PaperKind = System.Drawing.Printing.PaperKind.A3; cl_2.Landscape = true; cl_2.Margins.Right = 40; cl_2.Margins.Left = 40; cl_2.Links.AddRange(new object[] { pclChart2 }); cl_2.ShowPreviewDialog(); }
private void Export_Error_Tab() { load_Progressbar.Start_progres(); DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink cl = new DevExpress.XtraPrintingLinks.CompositeLink(ps); DevExpress.XtraPrinting.PrintableComponentLink pclChart = new DevExpress.XtraPrinting.PrintableComponentLink(); chartControl1.Visible = true; pclChart.Component = chartControl1; cl.PaperKind = System.Drawing.Printing.PaperKind.A4; cl.Landscape = true; cl.Margins.Right = 40; cl.Margins.Left = 40; cl.Margins.Top = 40; cl.Margins.Bottom = 40; cl.Links.AddRange(new object[] { pclChart }); cl.ShowPreviewDialog(); }
private void ExportButton_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; // Obtain the current export options. PdfExportOptions options = new PdfExportOptions(); // Set Print Preview options. options.Compressed = false; options.ImageQuality = PdfJpegImageQuality.Highest; options.PdfACompatible = true; forceVitesseChart.OptionsPrint.SizeMode = DevExpress.XtraCharts.Printing.PrintSizeMode.Stretch; forceVitesseMChart.OptionsPrint.SizeMode = DevExpress.XtraCharts.Printing.PrintSizeMode.Stretch; forcePositionChart.OptionsPrint.SizeMode = DevExpress.XtraCharts.Printing.PrintSizeMode.Stretch; PrintableComponentLink link1 = new PrintableComponentLink(); PrintableComponentLink link2 = new PrintableComponentLink(); PrintableComponentLink link3 = new PrintableComponentLink(); var composentlink = new DevExpress.XtraPrintingLinks.CompositeLink(new PrintingSystem()); link1.Component = forcePositionChart; link2.Component = forceVitesseChart; link3.Component = forceVitesseMChart; composentlink.Links.Add(link1); composentlink.Links.Add(link2); composentlink.Links.Add(link3); composentlink.Landscape = true; //page permettant de choisir l'emplacement et le nom du fichier pour l'enregistrement SaveFileDialog saveFileDialog1 = new SaveFileDialog(); if (saveFileDialog1.ShowDialog() == DialogResult.OK) { composentlink.ExportToPdf(saveFileDialog1.FileName + ".pdf", options); MessageBox.Show("Exportation réussie", "PDF"); } Cursor.Current = Cursors.Default; }
/// <summary> /// DevExpress控件通用导出Excel,支持多个控件同时导出在同一个Sheet表或者分不同工作薄 /// eg:ExportToXlsx("test",true,"控件",gridControl1,gridControl2); /// 将gridControl1和gridControl2的数据一同导出到同一个文件不同的工作薄 /// eg:ExportToXlsx("test",false,"",gridControl1,gridControl2); /// 将gridControl1和gridControl2的数据一同导出到同一个文件同一个的工作薄 /// <param name="FileName">Excel路径</param> /// <param name="isPageForEachLink">多个打印控件是否分多个工作薄显示</param> /// <param name="sheetName">工作薄名称</param> /// <param name="printables">控件集 eg:GridControl,PivotGridControl,TreeList,ChartControl...</param> public static void ExportToExcel(string FileName, bool isPageForEachLink, string sheetName, params DevExpress.XtraPrinting.IPrintable[] printables) { // SaveFileDialog saveFileDialog = new SaveFileDialog() // { // FileName = title, // Title = "导出Excel", // Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls" // }; // DialogResult dialogResult = saveFileDialog.ShowDialog(); // if (dialogResult == DialogResult.Cancel) // return; // string FileName = saveFileDialog.FileName; DevExpress.XtraPrintingLinks.CompositeLink link = new DevExpress.XtraPrintingLinks.CompositeLink(new DevExpress.XtraPrinting.PrintingSystem()); foreach (var item in printables) { var plink = new DevExpress.XtraPrinting.PrintableComponentLink() { Component = item }; link.Links.Add(plink); } if (isPageForEachLink) //15.1 的Xls不支持这个功能,15.2未知 { link.CreatePageForEachLink(); } //默认工作薄名称 if (string.IsNullOrEmpty(sheetName)) { sheetName = "Sheet"; } try { int count = 1; //在重复名称后加(序号) while (System.IO.File.Exists(FileName)) { if (FileName.Contains(").")) { int start = FileName.LastIndexOf("("); int end = FileName.LastIndexOf(").") - FileName.LastIndexOf("(") + 2; FileName = FileName.Replace(FileName.Substring(start, end), string.Format("({0}).", count)); } else { FileName = FileName.Replace(".", string.Format("({0}).", count)); } count++; } if (FileName.LastIndexOf(".xlsx") >= FileName.Length - 5) { DevExpress.XtraPrinting.XlsxExportOptions options = new DevExpress.XtraPrinting.XlsxExportOptions(TextExportMode.Value, true, false, true) { SheetName = sheetName }; if (isPageForEachLink) { options.ExportMode = DevExpress.XtraPrinting.XlsxExportMode.SingleFilePageByPage; } link.ExportToXlsx(FileName, options); } else { DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions(TextExportMode.Value, true, false, true) { SheetName = sheetName }; if (isPageForEachLink) //15.Xls没有这个属性,15.2未知 { options.ExportMode = DevExpress.XtraPrinting.XlsExportMode.SingleFilePageByPage; } link.ExportToXls(FileName, options); } if (DevExpress.XtraEditors.XtraMessageBox.Show("保存成功,是否打开文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { System.Diagnostics.Process.Start(FileName); //打开指定路径下的文件 } } catch (Exception ex) { DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message); } }
private void barButton_File_ItemClick(object sender, ItemClickEventArgs e) { //打开 if (e.Item.Name == nameof(barButton_Open) || e.Item.Name == nameof(ToolButton_Open)) { CETCManagerApp.Instance.OnFileOpen(); } //保存 else if (e.Item.Name == nameof(barButton_Save) || e.Item.Name == nameof(ToolButton_Save)) { CETCManagerApp.Instance.OnFileSave(); } //另存为 else if (e.Item.Name == nameof(barButton_SaveAs) || e.Item.Name == nameof(ToolButton_SaveAs)) { CETCManagerApp.Instance.OnFileSaveAs(); } //打印 else if (e.Item.Name == nameof(barButton_Print) || e.Item.Name == nameof(ToolButton_Print)) { IDD_PAGE_PRINT iDD_PAGE_PRINT = new IDD_PAGE_PRINT(); MultiLanguage.LoadLanguage(iDD_PAGE_PRINT, typeof(IDD_PAGE_PRINT)); iDD_PAGE_PRINT.ShowDialog(); } //打印预览 else if (e.Item.Name == nameof(barButton_PrintPreView) || e.Item.Name == nameof(ToolButton_PrintPreView)) { IDD_PAGE_PRINT iDD_PAGE_PRINT = new IDD_PAGE_PRINT(); MultiLanguage.LoadLanguage(iDD_PAGE_PRINT, typeof(IDD_PAGE_PRINT)); iDD_PAGE_PRINT.ShowDialog(); } //报表设置 else if (e.Item.Name == nameof(barButton_ReportSetup)) { } //导出PDF else if (e.Item.Name == nameof(barButton_ExportPDF) || e.Item.Name == nameof(ToolButton_ExportPDF)) { } //导出WORD else if (e.Item.Name == nameof(barButton_ExportWORD) || e.Item.Name == nameof(ToolButton_ExportWORD)) { PrintingSystem ps = new PrintingSystem(); DevExpress.XtraPrintingLinks.CompositeLink compositeLink = new DevExpress.XtraPrintingLinks.CompositeLink(); compositeLink.PrintingSystem = ps; PrintableComponentLink link = new PrintableComponentLink(); var c = main_TempChart.GetChart(); //Size size = c.Size; //c.Dock = DockStyle.None; //c.Size = new Size(400, 278); MemoryStream ms = new MemoryStream(); c.ExportToImage(ms, ImageFormat.Bmp); PictureEdit pe = new PictureEdit(); link.Images.Add(Image.FromStream(ms)); link.Component = c; compositeLink.Links.Add(link); link = new PrintableComponentLink(); link.Component = main_DataAnasis.GetGridControl(0); compositeLink.Links.Add(link); compositeLink.CreateDocument(); compositeLink.ShowPreview(); } //发送EMAIL else if (e.Item.Name == nameof(barButton_SendEMail) || e.Item.Name == nameof(ToolButton_SendEMail)) { } //离开 else if (e.Item.Name == nameof(barButton_Exit)) { Close(); } }