Hyperlink with sheet.ImportDataTable

[Chris Stout]

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:

http://help.syncfusion.com/ug_73/xlsio/default.html

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]

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.

Regards,
Geetha