http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-export-excel.htm

C# Crystal Reports Export to Excel

Home

VB.NET

C#

ASP.NET

AJAX

.Net Framework

About

SiteMap
CSharp.Net-Informations.com

There are situations when we want to export Crystal reports to .xls format programmatically in C#. In these situations we can use ExportOptions for export the Crystal Reports to .xls format. Also we have to set ExcelFormatOptions and ExportFormatType.Excel . 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

Download Source Code

Print Source Code

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: