Missing xlsx export option

[Atipong]

Good evening everyone.

I'm trying to create new Web App then add 'Telerik Web Forms Report Viewer Forn R1 2019' to it.

My problem is export option : it should have .xlsx, .docx and pptx

Once I used R3 2018 , it work as I aspect

I also attach image. export 2018 is what i use to do and what I expect and export 2019 is what i struck.

PS. I'm not native English.

[Neli]

Hello Atipong,

Check if you have all of the required references listed in the Open XML SDK for Microsoft Office. You may also need to add a binding redirect in the Web.config file of the application through a piece of code like (when using DocumentFormat.OpenXml version 2.5.5631.0) :

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
  <dependentAssembly>
    <assemblyIdentity name="DocumentFormat.OpenXml" publicKeyToken="31bf3856ad364e35" culture="neutral"/>
    <bindingRedirect oldVersion="0.0.0.0-2.5.5631.0" newVersion="2.5.5631.0" />
  </dependentAssembly>
</assemblyBinding>

For more information, you can refer to Missing DOCX, XLSX, PPTX, XPS export options KB Article.

Note also that there is a known issue with our latest official release (13.0.19.116) described in the Telerik Reporting R1 2019 fails to load assembly DocumentFormat.OpenXml 2.7.2+ KB article.

Regards,
Neli
Progress Telerik

[Atipong]

Seem my problem is that issue. After I try using DocumentFormat.OpenXml 2.5.5631.0 with a binding redirect, things work as my expectation. Thank you Neli 

[Michael]

Is there an article on how to set this up in an ASP.NET Core 3.1 app? If no, could you provide some direction on getting the Open XML setup (through npm?) and how to code the references in the appsettings.json or ...? Thank you.

[Michael]

In case someone comes to this post in the future wondering how to make it work in an ASP.NET Core 3.1 app, I finally found (after many attempts) the Telerik support article with the answer:

https://docs.telerik.com/reporting/telerik-reporting-rest-service-aspnetcore-mvc-core3?_ga=2.127093902.2045075754.1614055385-30531009.1587946536

then scroll down to the "Add the required dependencies" and you'll find the answer on item #2:

Optionally, for export to Office OpenXML document formats (XLSX, DOCX and PPTX) install the Telerik.Reporting.OpenXmlRendering (or Telerik.Reporting.OpenXmlRendering.Trial) NuGet package and the DocumentFormat.OpenXML NuGet package version 2.7.2.0 and above.

[Kevin]

-- Edited --

I had a silly issues with version differences between a newer build of Telerik.Reporting.OpenXmlRendering and the main Telerik.Reporting assembly. All seemed to work fine for the reporting engine, except it couldn't pick up open office formats.

Not sure anyone else will be as silly as me, but thought I'd mention it in case it helps anyone else having problems to triple check.

Kevin