Get Range with External Links with Golang via C++
Contents
[
Hide
]
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 a GetExternalFileName() property which returns the name of the external file. The ReferredArea class exposes the following members.
- GetEndColumn(): The end column of the area
- GetEndRow(): The end row of the area
- GetExternalFileName(): Gets 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
- GetSheetName(): Indicates which sheet this reference is in
- GetStartColumn(): The start column of the area
- GetStartRow(): The start row of the area
The sample code given below demonstrates the use of the Name.GetReferredAreas method to retrieve ranges with external links.