Hi to all,
I'm trying to create a solution console that it has generate a XLSX file from my report.
I'm using this code, it gives me an error "XLSX rendering format is not available." when execute reportProcessor.RenderReport()
Telerik.Reporting.Processing.RenderingResult EseguiReport(Telerik.Reporting.Report report,
string
format)
{
Telerik.Reporting.Processing.ReportProcessor reportProcessor =
new
Telerik.Reporting.Processing.ReportProcessor();
Telerik.Reporting.Processing.RenderingResult renderingResult = reportProcessor.RenderReport(format, report,
null
);
return
renderingResult;
}
I have already add these dll:
DocumentFormat.OpenXml version 2.8.1
Telerik.Reporting
Telerik.Reporting.OpenXmlRendering.2.7.2.dll
And added a bindingRedirect in the application configuration file for the DocumentFormat.OpenXml.dll assembly.
<
dependentAssembly
>
<
assemblyIdentity
name
=
"DocumentFormat.OpenXml"
publicKeyToken
=
"31bf3856ad364e35"
culture
=
"neutral"
/>
<
bindingRedirect
oldVersion
=
"0.0.0.0-2.8.1.0"
newVersion
=
"2.8.1.0"
/>
</
dependentAssembly
>
Also, i set CopyLocal property must be set to True to make sure that the proper DocumentFormat.OpenXml.dll is copied in the project's Bin folder.