We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Hyperlink with sheet.ImportDataTable

Thread ID:





90428 Sep 30,2009 05:10 PM UTC Oct 2,2009 07:01 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Chris Stout
Asked On September 30, 2009 05:10 PM UTC

I have an excel template file that I've set up with filters, and I am just dropping in a datatable using the IMportDataTable method and it's working great.

One of the columms, is a url. I want the url to be a hyperlink to the website.

I see how I can normally create a hyperlink here:


the problem is, the only way I can see it working in my scenario, is if I forego using the ImportDataTable function and writing everything out row by row, and then forming the hyperlink.

Anyone know a simplier way to do this while still taking advantage of the ImportDataTAble?

Geetha M [Syncfusion]
Replied On October 2, 2009 07:01 AM UTC

Hi Chris,

Thank you for your interest in Syncfusion products.

Import DataTable method imports the data and it is not possible to identify the hyperlink. As you said, you may iterate through every cell and form hyperlink. This can also be done after importing DataTable.

Please try this and let me know if you have any further questions.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon