How to Update Excel Links through C#

Joined
Apr 8, 2006
Messages
1
Reaction score
0
Hi,
I have an excel spreadsheet that has some hyperlinks in it. I want to update those hyperlinks automatically. I can update the cell itself, but not the link to which this cell points by doing so:

Object[] args = new Object[1];
args[0] = "http://www.google.com";
aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args);


Can anyone tell me how I can update the Hyperlink through InvokeMember or any other call?

Thanks,
Bagh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top