This is a migrated thread and some comments may be shown as answers.

Missing xlsx export option

4 Answers 288 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Atipong
Top achievements
Rank 1
Atipong asked on 18 Feb 2019, 01:21 PM

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.

4 Answers, 1 is accepted

Sort by
1
Accepted
Neli
Telerik team
answered on 18 Feb 2019, 05:23 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Atipong
Top achievements
Rank 1
answered on 20 Feb 2019, 04:22 AM
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 
0
Michael
Top achievements
Rank 1
answered on 23 Feb 2021, 05:26 AM
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.
0
Michael
Top achievements
Rank 1
answered on 24 Feb 2021, 05:54 AM

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
Top achievements
Rank 1
commented on 06 Sep 2021, 11:43 PM | edited

-- 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

Tags
General Discussions
Asked by
Atipong
Top achievements
Rank 1
Answers by
Neli
Telerik team
Atipong
Top achievements
Rank 1
Michael
Top achievements
Rank 1
Share this question
or