CODEWITHSUNDEEP
c#excelinterop
topgun_ivard
topgun_ivard

Reputation: 8564

Manipulating Excel Data using Visual C#

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

Upvotes: 0

Views: 541

Answers (1)

Mau
Mau

Reputation: 14468

Have you tried Hyperlinks.Add?

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

Upvotes: 1

Related Questions