How to render report for XLSX?

[Robert]

I am trying to figure out how to render an excel report into the Office 2007 format but I keep getting errors that the report extension is corrupt.

What do I need to change here:

I have tried setting the filname to xlsx and the reponse content type to application/vnd.openxmlformats-officedocument.spreadsheetml.sheet with no luck.

Dim reportProcessor As New Telerik.Reporting.Processing.ReportProcessor()
Dim result As Telerik.Reporting.Processing.RenderingResult = reportProcessor.RenderReport("XLS", myReport, Nothing)
Dim fileName As String = result.DocumentName + ".xls"
    Response.Clear()
    Response.ContentType = "Application/XLS"
    Response.Cache.SetCacheability(HttpCacheability.Private)
    Response.Expires = -1
    Response.Buffer = False
    Response.AddHeader("Content-Disposition", String.Format("{0};FileName=""{1}""", "attachment", fileName))
    Response.OutputStream.Write(result.DocumentBytes, 0, result.DocumentBytes.Length)
    Response.End()

[Chavdar]

Hi Robert,

To render a report in the Office 2007 Excel Worksheet format you have to use "XLSX" for the first argument of the RenderReport method.

Best wishes,
Chavdar
the Telerik team

[Robert]

Dim result As Telerik.Reporting.Processing.RenderingResult = reportProcessor.RenderReport("XLSX", myReport, Nothing)

I get a RenderedNotAvailableException when I use "XLSX" as the first argument:

XLSX Redering format is not available.

Robert

[Chavdar]

Hello Robert,

Microsoft Office 2007 formats are available from the latest version of Telerik Reporting (Q1 2011) which we have just released. Please, upgrade and try again. Note that you also have to install Open XML SDK 2.0 for Microsoft Office as the new rendering extensions depend on it.

Greetings,
Chavdar
the Telerik team

[Robert]

Also needed to add a reference to Telerik.Reporting.OpenXmlRendering assembly in Web.Config.

Thanks

[Steve]

Hello Robert,

This information is available in the Deploying Applications using Telerik Reporting help section.

Greetings,
Steve
the Telerik team

[Sergey]

This link is broken now. Is there an actual link?

[Todor]

Here is the link to the updated article Deploying Web Applications. Note that the article is related to the legacy viewer that is no longer developed.

I strongly recommend to Migrate to the HTML5 Viewer from the old ASP.NET WebForms ReportViewer control.

[Matt]

Link is now broken. http://www.telerik.com/help/reporting/installation-deploying-on-server.html

[Stef]

Hello Matthew,

The deployment articles are moved per viewer. For example check Deploying Web Applications:

DOCX/PPTX/XLSX rendering extensions require Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above).

I hope this information helps you.

Regards,
Stef
Telerik