private void barButtonItem4_ItemClick(object sender, ItemClickEventArgs e) { try { CompositeLink complink = new CompositeLink(new PrintingSystem()); PrintableComponentLink linkTable1 = new PrintableComponentLink(); PrintableComponentLink linkTable2 = new PrintableComponentLink(); PrintableComponentLink linkDiff = new PrintableComponentLink(); linkTable1.Component = gcWeight; complink.Links.Add(linkTable1); linkTable2.Component = gcFuel; complink.Links.Add(linkTable2); linkDiff.Component = gcType; complink.Links.Add(linkDiff); complink.CreatePageForEachLink(); if (this.saveFileDialog.ShowDialog() == DialogResult.OK) { XlsxExportOptions option = new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage }; complink.ExportToXlsx(saveFileDialog.FileName, option); if (MessageBox.Show("保存成功,是否打开文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { System.Diagnostics.Process.Start(saveFileDialog.FileName); } } } catch (Exception ex) { MessageBox.Show("导出失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void xuatExcel() { string ten_cautruyvan = ""; if (this.lookUpEditCauTruyVan.EditValue.ToString() != "Tên Câu Truy Vấn") { ten_cautruyvan = this.lookUpEditCauTruyVan.Text.ToString(); } SaveFileDialog f = new SaveFileDialog(); f.Filter = "Excel file (*.xlsx)|*.xlsx"; f.FileName = tenCSKCB + "_DichVuKyThuat_" + ten_cautruyvan + "_" + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); if (f.ShowDialog() == DialogResult.OK) { CompositeLink complink = new CompositeLink(new PrintingSystem()); PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem()); link.Component = this.gridControlKetQua; link.CreateMarginalHeaderArea += new CreateAreaEventHandler(Link_CreateMarginalHeaderArea_1); complink.Links.Add(link); //Rename Sheet complink.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated_1; complink.CreatePageForEachLink(); XlsxExportOptions options = new XlsxExportOptions(); options.ExportMode = XlsxExportMode.SingleFilePageByPage; complink.ExportToXlsx(f.FileName, options); MessageBox.Show("Xuất Excel Thành Công!"); } }
private void xuatExcel() { SaveFileDialog f = new SaveFileDialog(); f.Filter = "Excel file (*.xlsx)|*.xlsx"; f.FileName = "DichVuKyThuat_" + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); if (f.ShowDialog() == DialogResult.OK) { /* * CompositeLink complink = new CompositeLink(new PrintingSystem()); * PrintableComponentLink link = new PrintableComponentLink(new PrintingSystem()); * link.Component = this.gridControlCSKCB; * link.CreateMarginalHeaderArea += new CreateAreaEventHandler(Link_CreateMarginalHeaderArea); * complink.Links.Add(link); */ //Rename Sheet complinkMain.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated; complinkMain.CreatePageForEachLink(); XlsxExportOptions options = new XlsxExportOptions(); options.ExportMode = XlsxExportMode.SingleFilePageByPage; complinkMain.ExportToXlsx(f.FileName, options); flag_i = 0; MessageBox.Show("Xuất Excel Thành Công!"); } }
private void btn_Export_Click(object sender, EventArgs e) { try { SplashScreenManager.ShowForm(this, typeof(Masters.WaitForm1), true, true, false); if (pivotGridControlBreakHours.DataSource == null && pivotGridControlSummary.DataSource == null && pivotGridControlIdleHours.DataSource == null) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Data not found, cannot export"); return; } PivotGridControl[] pivotGrids = new PivotGridControl[] { pivotGridControlSummary, pivotGridControlIdleHours, pivotGridControlBreakHours }; PrintingSystem ps = new PrintingSystem(); ps.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls, PrintingSystemCommand.Open }, CommandVisibility.All); ps.XlSheetCreated += PrintingSystem_XlSheetCreated; CompositeLink cl = new CompositeLink(ps); PrintableComponentLink linkSummary = new PrintableComponentLink(); linkSummary.Component = pivotGridControlSummary; linkSummary.PaperName = "Summary"; PrintableComponentLink linkIdle = new PrintableComponentLink(); linkIdle.Component = pivotGridControlIdleHours; linkIdle.PaperName = "Idle Hours"; PrintableComponentLink linkBreak = new PrintableComponentLink(); linkBreak.Component = pivotGridControlBreakHours; linkBreak.PaperName = "Break Hours"; cl.Links.AddRange(new object[] { linkSummary, linkIdle, linkBreak }); cl.CreatePageForEachLink(); string filePath = @"C:\Break Idle Reports\"; string fileName = filePath + "Break Idle Reports All-" + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + ".xlsx"; SplashScreenManager.ShowForm(this, typeof(Masters.WaitForm1), true, true, false); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); Export(cl, fileName); } else { Export(cl, fileName); } } catch (Exception ex) { throw ex; } finally { SplashScreenManager.CloseForm(false); } }
protected override void CreateDocument(CompositeLink link) { if (link.Links.Count > 1) { link.CreatePageForEachLink(); } else { base.CreateDocument(link); } }
private void ExportSummary() { try { gridViewAccuracyDetails.Columns.ColumnByFieldName("Client_Order_Number").SummaryItem.SummaryType = SummaryItemType.None; gridViewErrors.Columns.ColumnByFieldName("Client_Order_Number").SummaryItem.SummaryType = SummaryItemType.None; SplashScreenManager.ShowForm(this, typeof(Masters.WaitForm1), true, true, false); PrintingSystem ps = new PrintingSystem(); CompositeLink compositeLink = new CompositeLink(ps); PrintableComponentLink linkAccuracy = new PrintableComponentLink(); linkAccuracy.Component = gridControlAccuracy; PrintableComponentLink linkChart = new PrintableComponentLink(); linkChart.Component = chartControlAccuracy; PrintableComponentLink linkAccuracyDetails = new PrintableComponentLink(); linkAccuracyDetails.Component = gridControlAccuracyDetails; PrintableComponentLink linkErrors = new PrintableComponentLink(); linkErrors.Component = gridControlErrors; ps.SetCommandVisibility(PrintingSystemCommand.Open, CommandVisibility.All); ps.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls }, CommandVisibility.All); compositeLink.Links.AddRange(new object[] { linkAccuracy, linkChart, linkAccuracyDetails, linkErrors }); string ReportName = "Accuracy Summary"; string folderPath = "C:\\Temp\\"; string Path1 = folderPath + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + "-" + ReportName + ".xlsx"; compositeLink.CreatePageForEachLink(); ps.XlSheetCreated += PrintingSystem_XlSheetCreated; compositeLink.PrintingSystem.ExportToXlsx(Path1, new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage, ExportHyperlinks = false, TextExportMode = TextExportMode.Value, IgnoreErrors = XlIgnoreErrors.NumberStoredAsText }); System.Diagnostics.Process.Start(Path1); } catch (Exception ex) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Something went wrong"); } finally { gridViewAccuracyDetails.Columns.ColumnByFieldName("Client_Order_Number").SummaryItem.SummaryType = SummaryItemType.Count; gridViewErrors.Columns.ColumnByFieldName("Client_Order_Number").SummaryItem.SummaryType = SummaryItemType.Count; SplashScreenManager.CloseForm(false); } }
private void btn_Export_Click(object sender, EventArgs e) { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); if (layoutView1.DataSource == null) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Data Not Found,Can't Export"); return; } PrintingSystem ps = new PrintingSystem(); ps.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls, PrintingSystemCommand.Open }, CommandVisibility.All); ps.XlSheetCreated += PrintingSystem_XlSheetCreated; CompositeLink cl = new CompositeLink(ps); PrintableComponentLink linknotification = new PrintableComponentLink(); linknotification.Component = grid_notification; linknotification.PaperName = "General Notification"; cl.Links.AddRange(new object[] { linknotification }); cl.CreatePageForEachLink(); string filePath = @"C:\General Notification\"; string fileName = filePath + "Gereral Notification All-" + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + ".xlsx"; SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); Export(cl, fileName); } else { Export(cl, fileName); } } catch (Exception ex) { SplashScreenManager.CloseForm(false); throw ex; } finally { SplashScreenManager.CloseForm(false); } }
private void barButtonItem4_ItemClick(object sender, ItemClickEventArgs e) { try { CompositeLink complink = new CompositeLink(new PrintingSystem()); PrintableComponentLink linkTable1 = new PrintableComponentLink(); PrintableComponentLink linkTable2 = new PrintableComponentLink(); PrintableComponentLink linkDiff = new PrintableComponentLink(); linkTable1.Component = gcTable1; complink.Links.Add(linkTable1); linkTable2.Component = gcTable2; complink.Links.Add(linkTable2); linkDiff.Component = gcTable3; complink.Links.Add(linkDiff); if (gcTable1.MainView.RowCount == 0 && gcTable2.MainView.RowCount == 0 && gcTable3.MainView.RowCount == 0) { return; } else { complink.CreatePageForEachLink(); SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Title = "导出Excel"; saveFileDialog.Filter = "Excel文件(*.xlsx)|*.xlsx"; saveFileDialog.FileName = "通告比对结果"; DialogResult dialogResult = saveFileDialog.ShowDialog(this); if (dialogResult == DialogResult.OK) { XlsxExportOptions option = new XlsxExportOptions(); option.ExportMode = XlsxExportMode.SingleFilePageByPage; complink.ExportToXlsx(saveFileDialog.FileName, option); MessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show("导出失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void Excel_Import() { CompositeLink complink = new CompositeLink(new PrintingSystem()); PrintableComponentLink link = new PrintableComponentLink(); link.Component = gridControl1; complink.Links.Add(link); complink.CreatePageForEachLink(); complink.ExportToXlsx("file1.xlsx", new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage }); }
private void xuatExcel_ToanBoCauLenh() { SaveFileDialog f = new SaveFileDialog(); f.Filter = "Excel file (*.xlsx)|*.xlsx"; f.FileName = tenCSKCB + "_DichVuKyThuat_" + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); if (f.ShowDialog() == DialogResult.OK) { //Rename Sheet complinkMain.PrintingSystem.XlSheetCreated += PrintingSystem_XlSheetCreated; complinkMain.CreatePageForEachLink(); XlsxExportOptions options = new XlsxExportOptions(); options.ExportMode = XlsxExportMode.SingleFilePageByPage; complinkMain.ExportToXlsx(f.FileName, options); flag_i = 0; MessageBox.Show("Xuất Excel Thành Công!"); } }
private void ExportOrderHistory() { try { SplashScreenManager.ShowForm(this, typeof(Masters.WaitForm1), true, true, false); PrintingSystem ps = new PrintingSystem(); CompositeLink compositeLink = new CompositeLink(ps); PrintableComponentLink LinkOrderhistory = new PrintableComponentLink(); LinkOrderhistory.Component = gridControlOrderHistory; PrintableComponentLink LinkOrderStatusHistory = new PrintableComponentLink(); LinkOrderStatusHistory.Component = gridControlOrderStatusHistory; ps.SetCommandVisibility(PrintingSystemCommand.Open, CommandVisibility.All); ps.SetCommandVisibility(new PrintingSystemCommand[] { PrintingSystemCommand.ExportCsv, PrintingSystemCommand.ExportTxt, PrintingSystemCommand.ExportXlsx, PrintingSystemCommand.ExportDocx, PrintingSystemCommand.ExportXls }, CommandVisibility.All); compositeLink.Links.AddRange(new object[] { LinkOrderhistory, LinkOrderStatusHistory }); string ReportName = "Order History"; string folderPath = "C:\\Temp\\"; string Path1 = folderPath + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + "-" + ReportName + ".xlsx"; compositeLink.CreatePageForEachLink(); ps.XlSheetCreated += PrintingSystem_XlSheetCreated; compositeLink.PrintingSystem.ExportToXlsx(Path1, new XlsxExportOptions() { ExportMode = XlsxExportMode.SingleFilePageByPage, ExportHyperlinks = false, TextExportMode = TextExportMode.Value, IgnoreErrors = XlIgnoreErrors.NumberStoredAsText }); System.Diagnostics.Process.Start(Path1); } catch (Exception e) { throw e; } finally { SplashScreenManager.CloseForm(false); } }