C# Crystal Reports Export to Excel

In certain scenarios, there arises a need to programmatically export Crystal Reports to the widely recognized .xls format within the C# programming language. During such instances, we can effectively utilize the ExportOptions functionality to facilitate the seamless conversion of Crystal Reports into the desired .xls format. Furthermore, it is crucial to configure and apply the ExcelFormatOptions in conjunction with the ExportFormatType.Excel to ensure precise and efficient exportation of the reports. In the following example you can see how to export a Crystal Reports as a Excel format file.

All C# Crystal Reports Tutorial in this website is based on the following database - crystaldb. So before you begin this section , please take a look at the database structure of crystaldb - Click Here C# crystaldb

If you are new to Crystal Reports and do not know how to create Crystal Reports from C# , please take a look at the section step by step tutorial for creating a Crystal Reports from C#.

In this section we are using our earlier program step by step tutorial for creating a Crystal Reports from C# for pull data from database to Crystal Reports . Before we start this section take a look at the step by step tutorial for creating a Crystal Reports from C# .

Here we are generating a Crystal Report from Product table and export the report content to an Excel format file.

Select the default form (Form1.cs) you created in C# and drag two buttons (Button1, Button2 ) and a CrystalReportViewer control to your form.

You have to include CrystalDecisions.CrystalReports.Engine in your C# Source Code.

using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared;

Copy and paste the following source code and run your C# project.

Full Source C#
using System; using System.Windows.Forms; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; namespace WindowsApplication1 { public partial class Form1 : Form { ReportDocument cryRpt; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { cryRpt = new ReportDocument(); cryRpt.Load(PUT CRYSTAL REPORT PATH HERE\\CrystalReport1.rpt"); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } private void button2_Click(object sender, EventArgs e) { try { ExportOptions CrExportOptions ; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); ExcelFormatOptions CrFormatTypeOptions = new ExcelFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net-informations.xls"; CrExportOptions = cryRpt.ExportOptions; CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.Excel; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; cryRpt.Export(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }

cryRpt.Load(PUT CRYSTAL REPORT PATH HERE\\CrystalReport1.rpt");

The Crystal Reports file path in your project files location, there you can see CrystalReport1.rpt . So give the full path name of Crystal Reports file like c:\projects\crystalreports\CrystalReport1.rpt

When you run this program you will get the Excel file (csharp.net-informations.xls) in your computer's C:






Related Topics
  1. C# Crystal Reports sample databse
  2. C# Crystal Reports step by step
  3. C# Crystal Reports from multiple tables
  4. C# Crystal Reports String parameter
  1. C# Crystal Reports Integer parameter
  2. C# Crystal Reports Date parameter
  3. C# Crystal Reports Dynamic Logon parameters
  4. C# Crystal Reports Formula Field
  5. C# Crystal Reports Summary Field
  6. C# Crystal Reports Export to Pdf
  7. Email Crystal Reports from C# Application
  8. C# Crystal Reports without database
  9. C# Crystal Reports from SQL Query
  10. Dynamic Crystal Reports from C# Application
  11. C# Crystal Reports from XML
  12. C# Crystal Reports - sub reports
  13. C# Crystal Reports - on demand sub reports
  14. C# Crystal Reports - Date to Date
  15. How to print Crystal Reports in C#
  16. How to deploy Crystal Report
  17. How to Crystal Report Merge Module