Missing export formats

[Tomica]

I am running the latest version of Telerik Reporting using the Control Panel app.  (Version=7.0.13.426)

This is a VS 2012 VB website, and I have verified the presence of the OpenXMLRendering.dll in the BIN directory.

When viewing a report my export options do not include DOCX or XLSX.

I have checked my web.config file and it appears to have the proper entries.

My export options in the Report Viewer control match the intended selection, XLS, CSV and PDF, but do NOT include DOCX or XLSX.
 

<configSections>
  <section name="Telerik.Reporting" type="Telerik.Reporting.Processing.Config.ReportingConfigurationSection, Telerik.Reporting, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" allowLocation="true" allowDefinition="Everywhere" />
</configSections>
<Telerik.Reporting>
  <Extensions>
    <Render>
      <Extension name="IMAGE" visible="false" />
      <Extension name="MHTML" visible="false" />
      <Extension name="XLS" visible="true" />
      <Extension name="CSV" visible="true" />
      <Extension name="RTF" visible="false" />
      <Extension name="XPS" visible="false" />
      <Extension name="PDF" visible="true" />
      <Extension name="DOCX" visible="true" />
      <Extension name="XLSX" visible="true" >
      <Parameters>
          <Parameter name="DocumentAuthor" value="CGA debug" />
        </Parameters>
      </Extension>
    </Render>
  </Extensions>
</Telerik.Reporting>
<appSettings>

[Ivan Hristov]

Hi Tomica,

Apart from OpenXMLRendering.dll you should also make sure you have installed Open XML SDK 2.0 for Microsoft Office, as stated in this documentation article: Deploying Web Applications. If you would like to avoid the installation of Open XML SDK, you can reference the required DocumentFormat.OpenXml assembly from C:\Program Files (x86)\Telerik\Reporting Q3 2012\Examples\bin folder.

Regards,
Ivan Hristov
Telerik

[Nauman]

Hello tomica,

Did you find any solution for these missing extensions ? 

Regards,
Nauman Usmani

[Stef]

Hello Nauman,

If you refer to the OpenXML rendering extensions as XLSX, DOCX, PPTX, you need to add references to Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above). To use a greater version than DocumentFormat.OpenXml.dll v.2.0.5022.0 you need to add binding redirects in the start application's configuration file.


Regards,
Stef
Telerik

 

 

[Nauman]

Hello Stef,

thank you for your help, its all about putting "Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0" to the right Project, and everything is visible there.

I have one more question to ask, regarding the Parameters for '.XLSX' while exporting to Excel WorkBook , my cell style lost and it gives me error. please find the attachment to have a look. do we have any Parameter for this issue ? 
and from where did i get the list of Parameters for all Extensions.?


Regards,
Nauman Usmani

[Stef]

Hi Nauman,

The reason for the error might be in the used per report DocumentName.When you export a report document, the Excel sheet name is the value set for the report's DocumentName property. Excel has limitations in the naming of workbooks and sheets. Thus you need to avoid the described characters in the report's DocumentName property.

You can check also the Design Considerations for Excel Rendering article.

The full list of available rendering extensions is available in the Rendering Extensions help article. And information about the device settings for each in the Device Information Settings section.


If the above information does not help you to resolve the issue, please share the report file producing the erroneous Excel file.

Regards,
Stef
Telerik

 

 

[Saroj Kumar]

I am trying to export telerik gridview records into excel 2007 i.e. xlsx format.  I am using VS 2013.

Though its exported, but column formats are not coming correctly. Its working perfectly in .xls format. The only change in code i have done is :

 gridview1.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;

Can anyone help on this.

Thanks in advance.

 

 

[Nasko]

Hello Saroj Kumar,

Telerik Reporting does not contain a GridView item.

Please post a new thread with your inquiry in an appropriate forum section for the used product: Telerik Forums.

Regards,
Nasko
Telerik

[Saroj Kumar]

[quote]Nasko said:Hello Saroj Kumar,

Telerik Reporting does not contain a GridView item.

Please post a new thread with your inquiry in an appropriate forum section for the used product: Telerik Forums.

Regards,
Nasko
Telerik [/quote]