Get Range with External Links

Often, Excel files access data from other Excel files using external links. Aspose.Cells provides a way to retrieve these external links 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.

EndColumn: The end column of the area
EndRow: The end row of the area
ExternalFileName: Get the external file name if this is an external reference
IsArea: Indicates whether this is an area
IsExternalLink: Indicates whether this is an external link
SheetName: Indicates which sheet this reference is in
StartColumn: The start column of the area
StartRow: The start row of the area

The sample code below demonstrates how to use the Name.GetReferredAreas method to retrieve ranges with external links.

Sample Code