Hyperlink Problem

[andyww]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I have some code that exports data into excel. One of the columns is a hyperlink:

For example:

http://www.bbc.co.uk

The trouble is when I view this in excel it just appears as text, its only when I click enter does it actually turn into a valid hyperlink.

Anyway suggestions as to how I can fix this please?

Andy.

[Amjad_Sahi]

Hi,

Well, I think once you have imported data to the worksheet cells, you may add hyperlinks manually by using Aspose.Cells APIs. For example, you may loop through your Hyperlink column cells and add hyperlinks in each cell, the URL/Address would be cell’s string value (you may use cell.StringValue).

See the topic on how to add hyperlinks into Excel worksheet cells:

http://www.aspose.com/docs/display/cellsnet/Adding+Hyperlinks+to+Link+Data

Thank you.