Export Hyperlink to Excel

Fri Nov 04, 2011 5:10 pm

Hi all,
what I'm trying to do is export some data to an excel file.
The problem is that one of the columns is an hyperlink and I want Excel recognize its cells as an hyperlink instead of normal text (which is the default behaviour).
How can I perform that?
Thank in advance.

Mon Nov 07, 2011 3:34 am

hi to all www.e-iceblue.comers this is my frst post and thought i would say hello to you all -
thanks speak soon
garry m

Mon Nov 07, 2011 8:34 am

No response at all?

Mon Nov 07, 2011 10:03 am

Dear kherydan,

So sorry for the inconvenience! Becausre our technical support is a little busy, could you please kindly give us a little more time? We promise we will give you a solution within the next 24 hours. Thanks for your understanding and wish you have a great day!

Tue Nov 08, 2011 3:59 am

Dear kherydan,

Sorry for any inconveniences caused by us and thank you for your patience with our reply.

Spire.DataExport can't support the function you mentioned. If you want to add hyperlink in Excel only by manual, you can use the following code:
worksheet.AddHyperLink(3, 6, "Spire.DataExport", "http://www.e-iceblue.com");

If you still have any other questions, please feel free to contact us.
Have a nice day.

Tue Nov 08, 2011 11:06 am

Hi,
Can you please provide an export example using worksheet?
As far as I know there's only examples using Spire.DataExport.XLS.CellExport class.
And there's some method called every line of output excel where I can use your AddHyperlink to insert my iperlink as the last cell in current row?
I was wondering something like GetDataParams of CellExport class...
Thanks in advance for your kindness.

Best regards

Wed Nov 09, 2011 6:42 am

Hello kherydan,

Sorry for late reply.

I use Spire.DataExport to import dataTable into Excel. I sent you the demo by attachment. You can download it and have a try.

If you still have any other questions, Please don't hesitate to contact us.
Have a nice day.