Change External Link Question

Hi Laurence,



Thanks so much for adding this feature to your product. I was wondering
if you could demonstrate a quick example on how to change the external
links?



Thanks again,

Michael

Hi Michael,

Please try:

Excel excel = new Excel();
excel.Open("d:\\test\\book1.xls");
Console.WriteLine(excel.Worksheets.ExternalLinks[0].DataSource);

excel.Worksheets.ExternalLinks[0].DataSource = "d:\\test\\link2.xls";