Manipulating Excel Data using Visual C#

Question

Hi,
I need to set/insert hyperlinks for a range of values in an Excel sheet from my program written in Visual C#.
I am using "Microsoft.Office.Interop.Excel" and no third party Excel tools.

I have URLs in string format with me in the program which need to show up as Hyperlinks in the Excel workbook.

Any ideas on how this can be implemented? I did not see any familiar feature in Excel.Range which I could use. Any suggestions would be appreciated!

Thanks,
Ivar

Answer 1

Have you tried Hyperlinks.Add?

You can add a hyperlink to a range of cells (after setting the text content).