Export crystal report to excel data with HEADERS C#

Question

1.00/5 (1 vote)

See more:

VS2008

0
down vote
favorite
I'm trying to export the crystal report to Excel with HEADERS. When i use ExportFormatType.ExcelRecord we only get Data but not the headers(here we get .xls format). I know that ExportFormatType.Excel option will export with Headers but its in .CSV format with blanks and all which is of no use for the client to process the data further.

So wanted to know if there is any way to achieve this requirement where the formatting is good with HEADERS and process the data further.

Thanks.

What I have tried:

i have tried using

ExportFormatType.Excel

but it gives a csv file with the entire report like footer,report header etc.Tried formatting the report to my best to avoid blank spaces.But still get blank spaces in the Excel csv file.

Posted 20-Sep-17 20:19pm

Prathap Gangireddy

Updated 21-Sep-17 10:21am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

eddieangel · Accepted Answer · 2017-09-21T10:21:00

Try this solution (From MSDN)

// Declare variables and get the export options.
ExportOptions exportOpts = new ExportOptions();
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions ();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = Report.ExportOptions;

// Set the excel format options.
excelFormatOpts.ExcelUseConstantColumnWidth = true;
excelFormatOpts.ExcelTabHasColumnHeadings = true;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.FormatOptions = excelFormatOpts;

// Set the disk file options and export.
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = fileName;
exportOpts.DestinationOptions = diskOpts;

Report.Export ();

Pay special attention to the line:

excelFormatOpts.ExcelTabHasColumnHeadings = true;