Export Hyperlink to Excel

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

Export Hyperlink to Excel

Postby kherydan » 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.
kherydan
 
Posts: 3
Joined: Fri Nov 04, 2011 2:37 pm

work

Postby garrymoore » 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
garrymoore
 
Posts: 1
Joined: Fri Nov 04, 2011 3:07 pm

Re: Export Hyperlink to Excel

Postby kherydan » Mon Nov 07, 2011 8:34 am

No response at all? :(
kherydan
 
Posts: 3
Joined: Fri Nov 04, 2011 2:37 pm

Re: Export Hyperlink to Excel

Postby iceblue support » 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!
e-iceblue support
User avatar
iceblue support
 
Posts: 244
Joined: Tue Dec 21, 2010 2:56 am

Re: Export Hyperlink to Excel

Postby Tina.Lin » 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.
Tina
Technical Support/Developer,
e-iceblue Support Team
User avatar
Tina.Lin
 
Posts: 152
Joined: Tue Sep 13, 2011 5:37 am

Re: Export Hyperlink to Excel

Postby kherydan » 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
kherydan
 
Posts: 3
Joined: Fri Nov 04, 2011 2:37 pm

Re: Export Hyperlink to Excel

Postby Tina.Lin » 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.
Attachments
LineBreaksInExport.zip
(21.97 KiB) Downloaded 453 times
Tina
Technical Support/Developer,
e-iceblue Support Team
User avatar
Tina.Lin
 
Posts: 152
Joined: Tue Sep 13, 2011 5:37 am


Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 0 guests

cron