Documentation to update excel source links

Aspose.Cells Product Family
1

Hello,

Is anyone aware of any documentation on how to update source links in an excel document?

For example:
Open the Excel Ribbon -> Data Tab -> Queries & Connections -> Edit Links

I am trying to determine if its possible to modify and existing link source to provide a new url.

Thanks

2

@OpenDevSolutions,

See the following sample code on how to retrieve external links’ data source for your reference. You may change the source for your needs too:
e.g.
Sample code:

var workbook = new Aspose.Cells.Workbook("e:\\test2\\Book1.xlsx");
            if (workbook.HasExernalLinks()) //Process external links 
            {

                var links = workbook.Worksheets.ExternalLinks;

                for (int i = 0; i < links.Count; i++)
                {
                    Console.WriteLine(links[i].DataSource);
                    Console.WriteLine(links[i].IsReferred);
                    //you may also change the data source, etc. 
                    //....
                    //your code goes here
                    //.........  
                }
            }

Hope, this helps a bit.

3

Ill give this a shot.

Much appreciated!