Get Range with External Links

A lot of times Excel files access data from other Excel files using external links. Aspose.Cells provides the option to retrieve these external links by using the Name.GetReferredAreas method. The Name.GetReferredAreas method returns an array of type ReferredArea. The ReferredArea class provides an ExternalFileName property which returns the name of the external file. The ReferredArea class exposes the following members.

The sample code given below demonstrates the use of Name.GetReferredAreas method to get Ranges with external links.

Sample Code