Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

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

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

Mon Nov 07, 2011 8:34 am

No response at all? :(

kherydan
 
Posts: 3
Joined: Fri Nov 04, 2011 2:37 pm

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: 240
Joined: Tue Dec 21, 2010 2:56 am

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

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

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 806 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