Creating HTML Link in Excel


#1

Basically i want to create a HTML link in Excel but i dont know the correct code to do so. I just type in the web address like normal in a colum in Excel and when i convert it over into an html page it just shows the actually address of the link i typed.

For example:

I type in

http://www.abc123456789.com

The link shows up but it is not clickable its only normal text. I want it to come up as clickable.


#2

Hi, thanks for your consideration.

If you want to add a hyperlink in Cell A1 of the first worksheet, try the following code:

excel.Worksheets[0].Hyperlinks.Add(0, 0, 1, 1, "http://www.abc123456789.com ");