Missing export formats

9 posts, 0 answers
  1. Tomica
    Tomica avatar
    147 posts
    Member since:
    Apr 2008

    Posted 05 Jun 2013 Link to this post

    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>


  2. Ivan Hristov
    Admin
    Ivan Hristov avatar
    85 posts

    Posted 10 Jun 2013 Link to this post

    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

    Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

  3. DevCraft banner
  4. Nauman
    Nauman avatar
    7 posts
    Member since:
    May 2014

    Posted 28 Aug 2014 in reply to Tomica Link to this post

    Hello tomica,

    Did you find any solution for these missing extensions ? 

    Regards,
    Nauman Usmani
  5. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 01 Sep 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Nauman
    Nauman avatar
    7 posts
    Member since:
    May 2014

    Posted 02 Sep 2014 in reply to Stef Link to this post

    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
  7. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 04 Sep 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  8. Saroj Kumar
    Saroj Kumar avatar
    5 posts
    Member since:
    May 2015

    Posted 26 May 2015 Link to this post

    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.

     

     

  9. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 27 May 2015 Link to this post

    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
    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
  10. Saroj Kumar
    Saroj Kumar avatar
    5 posts
    Member since:
    May 2015

    Posted 27 May 2015 in reply to Nasko Link to this post

    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
    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
Back to Top
DevCraft banner