XLSX Rendering failure

[Joseph]

Hi,
I installed 2011 Q3 Telerik reporting framework. I tried to render my report in to XLSX it threw an exception "Telerik.Reporting.Processing.RendererNotAvailableException: XLSX rendering format is not available."

The code:

var reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("XLSX", report, null);
string reportFileName = @"C:\report" + DateTime.Now.Ticks + ".xslx";
FileStream fs = new FileStream(reportFileName, FileMode.Create);
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
fs.Flush();
fs.Close();

It worked for "XSL" extension not "XSLX".

Many Thanks
Joseph

[Steve]

Hello Joseph,

XLSX (and the other OpenXML rendering extensions) requires Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above). This information is available in the Deploying Applications using Telerik Reporting help section.

Kind regards,
Steve
the Telerik team

[Joseph]

Hi Steve,
I'm using Q3 which I've installed today to my local machine and it must be in GAC in theory. Currently testing in a console visual studio application. I referenced Telerik.Reporting.dll and Telerik.Reporting.OpenXmlRendering.dll file and mark them to copy locally. Still it failed with the same message. I don't think I need other Telerik dlls needs to be copied to the bin as all in GAC.

Thanks

[Steve]

Hello Joseph,

DocumentFormat.OpenXml.dll is not installed in GAC when you install Telerik Reporting. You can either install the OpenXML SDK as suggested in my previous post, or get the DocumentFormat.OpenXml.dll from C:\<Install Dir>\Telerik\Reporting Q3 2011\Examples\bin folder and add reference to it as well in your project.

All the best,
Steve
the Telerik team

[Joseph]

 Thanks for that I've installed Open XML SDK 2.0 and it works