private void exportButton_Click(object sender, EventArgs e) { var reportName = (string)reportsNames.SelectedItem; var exportType = (string)exportTypes.SelectedItem; IDocumentExportEx documentExportEx = null; var report = new SectionReport(); System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(@"..\..\..\..\Reports\" + reportName); report.LoadLayout(xtr); report.Run(); var exporTypeLower = exportType.ToLower(); switch (exporTypeLower) { case _pdf: documentExportEx = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport(); break; case _xlsx: documentExportEx = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport() { FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx }; break; case _rtf: documentExportEx = new GrapeCity.ActiveReports.Export.Word.Section.RtfExport(); break; case _mht: documentExportEx = new GrapeCity.ActiveReports.Export.Html.Section.HtmlExport(); break; case _csv: documentExportEx = new GrapeCity.ActiveReports.Export.Xml.Section.TextExport(); break; } var fileName = Path.GetFileNameWithoutExtension(reportName); var saveFileDialog = new SaveFileDialog() { FileName = fileName + GetSaveDialogExtension(exporTypeLower), Filter = GetSaveDialogFilter(exporTypeLower) }; if (saveFileDialog.ShowDialog() != DialogResult.OK) { return; } exportButton.Enabled = false; using (var stream = new FileStream(Path.Combine(saveFileDialog.FileName), FileMode.Create)) documentExportEx.Export(report.Document, stream); exportButton.Enabled = true; }
private void PrintActiveRecordsLabel(InventurlistenArt la) { PageDocument pageDocument = null; switch (la) { case InventurlistenArt.Zaehliste: { pageDocument = ActiveReportsTools <int> .GetDocument(StaticMethods.GetPath(@"Drucklisten\Inventurliste.rdlx")); pageDocument.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(pageDocument_LocateDataSource); break; } case InventurlistenArt.Differenzliste: { pageDocument = ActiveReportsTools <int> .GetDocument(StaticMethods.GetPath(@"Drucklisten\Differenzliste.rdlx")); pageDocument.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(pageDocument_LocateDataSource); break; } case InventurlistenArt.Artikelliste: { pageDocument = ActiveReportsTools <int> .GetDocument(StaticMethods.GetPath(@"Drucklisten\Artikelliste.rdlx")); pageDocument.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(pageDocument_LocateDataSource); if (DoExportExcel) { string fName = ConfigEntry <string> .GetConfigEntry("ArtikellisteExport", @"F:\ALLGEMEIN\EDV\Datenbank_Neu\Export\Artikellisten\liste.xls"); GrapeCity.ActiveReports.Export.Excel.Section.XlsExport XLSExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport(); XLSExport1.Export(pageDocument, fName); } break; } default: break; } viewer1.LoadDocument(pageDocument); }
private void ExcelSimpleButton_Click(object sender, EventArgs e) { try { var _file = string.Format(@"{0}.xlsx", DateTime.Now.Ticks); GrapeCity.ActiveReports.Export.Excel.Section.XlsExport PdfExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport(); PdfExport1.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx; PdfExport1.Export(this._doc, "ExportFile\\" + _file); if (MessageBox.Show("File Exported Successfully, Do You want to open File ?", "Export", MessageBoxButtons.YesNo) == DialogResult.Yes) { string windir = Environment.GetEnvironmentVariable("WINDIR"); Process prc = new Process(); prc.StartInfo.FileName = windir + @"\explorer.exe"; prc.StartInfo.Arguments = "ExportFile\\" + _file;; prc.Start(); } } catch (Exception ex) { Serilog.Log.Error(ex, "excel Export"); MessageBox.Show(ex.ToString()); } }