Manipulating Excel Data using Visual C#

I need to set/insert hyper开发者_如何学运维links 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

Have you tried Hyperlinks.Add?

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