Hi all,
I have following issue, I need to export report to excel in excel data only, but I also neet to keep column names which are in this case suppressed. Code I use is:
ExportRequestContext expReqCntxt = new ExportRequestContext();
CrystalDecisions.Shared.ExportOptions expOpts = new CrystalDecisions.Shared.ExportOptions();

expOpts.ExportFormatType = ExportFormatType.ExcelRecord;
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions();

excelFormatOpts.ExcelTabHasColumnHeadings = true;
excelFormatOpts.ExportPageHeadersAndFooters = ExportPageAreaKind.OncePerReport;

expOpts.ExportFormatOptions = excelFormatOpts;


expReqCntxt.ExportInfo = expOpts;

byte[] bStream = null;
System.IO.Stream stRpt;

stRpt = ((CrystalDecisions.CrystalReports.Engine.ReportDoc ument)reportDoc).FormatEngine.ExportToStream(expRe qCntxt);
bStream = new byte[stRpt.Length];

stRpt.Read(bStream, 0, Convert.ToInt32(stRpt.Length));

string contentType = "application/vnd.ms-excel"; // default html

context.Response.Buffer = true;
context.Response.Clear();

context.Response.ContentType = contentType;
context.Response.BinaryWrite(bStream);
context.Response.End();

Hi,

you can try using GemBox .NET component for Excel. Here you can see an example how to export data to Excel with this component.

Filip