Straight to Excel

[kelly moore]

I am looking for a way to export data to Excel without having to view a report. Is it possible to bypass the report and output straight to Excel?

[Steve]

Hello Kelly,

You can review this KB article that elaborates on the matter: Exporting a report to PDF programmatically. The first argument of the Telerik.Reporting.Processing.ReportProcessor.Render() method is the rendering extension to be used. In your case it would be XLS instead of PDF.

Regards,
Steve
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[kelly moore]

Works perfect. Thank you!

[Patrick]

Not for me, all I'm getting is this:

late" type="text/x-jquery-tmpl">

${Title} Delete bookmark

 

[Steve]

Hello Patrick,

This forum post is about 4 years old. The suggested method Render is now obsolete and a quick look at the documentation (Exporting Report Programmatically) and API would show you how to use the new RenderReport method.
If you continue to have problems, please elaborate where do you get this? Have you tried on another report or it's happening on a specific report? Have you tried exporting to the OpenXML format i.e. use XLSX as argument of the RenderReport method.

If you need further help, it would be best to open a support ticket and attach a sample runnable project that exhibits the problem.

Greetings,
Steve
the Telerik team

[Patrick]

I've viewed the code in the KB article you mentioned. Do you have an example of using this same methodology to stream the exported .xls file to the user from a web application with the "Open", "Save" dialog?

Thanks,

--Patrick

[Patrick]

Never mind my request for an example. I believe I've got it figured out. Bear in mind that we're using Telerik Report v.5.3.11.1222 (Q3 2011) in this project. I'm posting this in case someone else runs into a similar situation:

using (IReportDocument reportDocument = new BCRDetailReport(budgetCode, cbcCode, cbaCode, bcrStatus))
{
  ReportProcessor reportProcessor = new ReportProcessor();
  RenderingResult result = reportProcessor.RenderReport("XLS", reportDocument, null);
  string outputFile = string.Format("{0}.{1}", result.DocumentName, result.Extension);
  Response.Clear();
  Response.ContentType = result.MimeType;
  Response.Cache.SetCacheability(HttpCacheability.Private);
  Response.Expires = -1;
  Response.Buffer = true;
  Response.AddHeader("Content-Disposition", string.Format("{0};filename=\"{1}\"", "attachment", outputFile));
  Response.BinaryWrite(result.DocumentBytes);
  HttpContext.Current.ApplicationInstance.CompleteRequest();
}