Hyperlink not working when Exported to Excel

9 posts, 0 answers
  1. Gregory
    Gregory avatar
    4 posts
    Member since:
    Apr 2011

    Posted 18 May 2011 Link to this post

    I'm using the hyperlink on a Textbox (not a HTMLTextbox but rather a plain Textbox).   I did this via the Action property and selecting Navigate to URL with Link Selected set to NewWindow.   The target URL is set to the following expression:

    = Parameters.URLPrefix.Value + CStr(Fields.SERVICEREQUESTIDNUM)

    It works great in the Report Viewer and when I export it as a PDF, but not in Excel.   How do I fix this?   Is this an Excel setting that is preventing me from hyperlinking.  Thanks.
  2. Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 23 May 2011 Link to this post

    Hello Gregory,

    Currently Telerik Reporting supports two Excel formats: Microsoft Excel 97-2003 (BIFF, v.8) and Microsoft Excel 2007 and above (OpenXML 2.0). One of the differences between them is the hyperlink support. Please, make sure you are exporting to Excel 2007 in order to have working hyperlinks. More information about the Excel rendering extensions you can find in the Design Considerations for Excel Rendering help article.

    Kind regards,
    Chavdar
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
  4. Gregory
    Gregory avatar
    4 posts
    Member since:
    Apr 2011

    Posted 23 May 2011 Link to this post

    The only export options I have are:

    Acrobat
    CSV
    Excel 97-2003
    Rich Text Format
    TIFF
    Web Archive
    XPS

    I running Telerik reporting Q1.
  5. Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 24 May 2011 Link to this post

    Hi Gregory,

    It seems like the new Open XML rendering extensions (Word, PowerPoint, Excel 2007) are missing from the export options. To enable them you have to reference
    To avoid the installation of the Open XML SDK you can reference the required assembly from C:\Program Files (x86)\Telerik\Reporting Q1 2011\Examples\bin folder. Note that they require .NET Framework 3.5 SP1 to be installed first.

    Hope this helps.

    Regards,
    Chavdar
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
  6. Gregory
    Gregory avatar
    4 posts
    Member since:
    Apr 2011

    Posted 24 May 2011 Link to this post

    Once I added both the Telerik.Reporting.OpenXmlRendering.dll and DocumentFormat.OpenXml.dll to the references, the web viewer (I using the webform version) started showing the extra export options.   Interesting that the OpenXML options just say Word Document, Excel Worksheet, and Powerpoint Presentation and do not say "2007" anywhere.   That works for me (I probably a good thing not to go that specific).    The hyperlinks now work!     Thanks for you help!
  7. Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 24 May 2011 Link to this post

    Hello Gregory,

    You are correct. The official name of the rendering extension is Excel Worksheet. Open XML file formats were introduced with Office 2007 so you may refer to it also as Excel 2007.

    Best wishes,
    Chavdar
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
  8. Sam
    Sam avatar
    60 posts
    Member since:
    Mar 2011

    Posted 14 Mar Link to this post

    This is an old post but I'm hoping someone can help me. I am trying to export my report to an Excel file and I've installed the OpenXML 2.0 to get the extra options as noted above. However my links still won't export. I've tried the Excel Worksheet as well as the Excel 97-2003 options and neither works. It exports fine to PDF and Word but just not Excel. I am setting the hyperlink via the value field for an HTML text box. I've also tried setting the Navigate To Url property and that doesn't work either. Any help would be appreciated. 

     

  9. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 16 Mar Link to this post

    Hello Sam,

    In XLS files interactivity is not supported. In XLSX files you can have clickable links opening content in the machine's default browser. Note that the HtmlTextBox content is rendered without any formatting in Excel - Design Considerations for Excel Rendering.
    Using a NavigateToUrlAction on a TextBox item works as expected, test with Telerik Reporting Q1 2016 SP1.

    To generate an XLSX file, in the start project you need to have 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 with proper binding redirect).


    Let us know if you have any further questions.

    Regards,
    Stef
    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. Sam
    Sam avatar
    60 posts
    Member since:
    Mar 2011

    Posted 16 Mar in reply to Stef Link to this post

    Thanks Stef for the reply. I'm using TextBox instead. 
Back to Top
DevCraft banner