Rank 1
I am currently using Telerik Reporting version 15.1.21.616 (R2 2021 SP1) in my ASP.NET application. I noticed that the report viewer only exports to the legacy Excel format (.XLS) and there is no option for Excel (.XLSX) in the export formats.
I have checked the Bin directory of my installation, and I do not see the Telerik.Reporting.XlsxRendering.dll assembly, which I understand is required for XLSX export.
1 Answer, 1 is accepted
Hi Thuvaragan,
Thank you for reaching out.
XLSX rendering extensions are OpenXML formats and they require the Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above).
If you use 'DocumentFormat.OpenXml 3.1.0' you have to install the 'Telerik.Reporting.OpenXmlRendering3' NuGet package. For more information, you can look at this link - Third-Party Dependencies for Enriching Reporting Functionalities - Telerik Reporting.
For more information on the topic, please visit the OpenXML and XPS options not visible. Unavailable rendering format - Telerik Reporting article.
I hope the above information will be useful. Let me know if you have other questions.
Regards,
Ivet
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 1
Still Telerik Reporting (v15.1.21.616) Only Shows "Excel97-2003" Export Option Instead of XLSX
Environment:
Telerik Reporting: 15.1.21.616
Telerik.Reporting.OpenXmlRendering: 15.1.21.616
DocumentFormat.OpenXml: 2.0.5022.0
Could you tell me if you are using NuGet or dll? If you are using NuGet, it provides DocumentFormat.OpenXml 2.7.2, and you need to set up a binding redirect - Use Telerik Reporting with newer OpenXML SDK version - Telerik Reporting.
If this doesn't help, could you please provide the app so I can test it and try to find a solution? Also, it will be really helpful if you send me а Trace log. You can also check in the Modules Window to see if the DLLs are being loaded - View DLLs and executables in Visual Studio - Visual Studio Modules window | Microsoft Learn.
If you are hesitant to send your project here, you can open a ticket and provide the details there.