Telerik reports not having excel export option in licensed version

[Parimal]

Hi Team,

We are using Telerik reporting service license and have developed reports but our reports are not having excel export option, however the same is working with the trial version of the product in our local environment. but not with the licensed version.

We are using Asp.Net core version 3.1.

We have tried below articles but no luck so far:

1. https://docs.telerik.com/reporting/using-reports-in-applications/dot-net-core-support

2. https://docs.telerik.com/reporting/knowledge-base/missing-docx-xlsx-pptx-xps-export-options

3. https://www.telerik.com/forums/telerik-report-only-have-pdf-excel-and-word-are-missing

Any urgent help will be appreciated.

 

Thanks,

Markandey Pandey

 

 

 

[Todor]

Hello Markandey,

I noticed that you have opened a Support Ticket for the same issue, where we have already responded. For the benefit of the community, I will summarize our response also here.

Generally, the Trial version of our product is fully functional. That said, it is identical to the purchase version. The only difference is the red trial message that we add to the reports when rendered with the trial version.

In order to export to Open XML like XLSX, you need to add references to two additional assemblies/packages. For .NET Core/5/6 these packages are Telerik.Reporting.OpenXmlRendering and DocumentFormat.OpenXml 2.7.2+. If you use Nuget packages, you may add only the former and it will automatically add the latter as a dependency - see the linked screenshot for reference. This should do in order to have the exports to Word, Excel, and PowerPoint available in your Reporting solution.

It's important to note also that all the reporting resources that interact should match in version. If the Telerik.Reporting.OpenXmlRendering is with a different version from the rest of the Reporting assemblies, the Reporting service and engine won't be able to find the Telerik.Reporting.OpenXmlRendering assembly and the Open XML renderings won't be available.

Regards,
Todor
Progress Telerik

[Francis]

I get this:

Could not load type 'DocumentFormat.OpenXml.Packaging.ImagePartType' from assembly 'Telerik.Reporting.OpenXmlRendering.2.7.2, Version=17.2.23.1114, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' due to value type mismatch.
   at Telerik.Reporting.OpenXmlRendering.Wordprocessing.DocumentHelper..cctor()

 

 

[Dimitar]

Hello Francis,

This is a known issue that appears when the referenced DocumentFormat libraries are of version 3.0 or newer. The issue is already logged on the feedback portal and I noticed that you have cast your vote for it which should further increase its priority - OpenXML renderings should work with DocumentFormat.OpenXml 3.0.0 and newer (telerik.com).

Currently, the workaround is to use version 2.20.0 or older of the DocumentFormat.OpenXml library to avoid this problem.