Get Range with External Links
Contents
[
Hide
]
Get Range with External Links
A lot of times Excel files access data from other Excel files using external links. Aspose.Cells for Python via .NET provides the option to retrieve these external links by using the Name.get_referred_areas method. The Name.get_referred_areas method returns an array of type ReferredArea. The ReferredArea class provides an external_file_name property which returns the name of the external file. The ReferredArea class exposes the following members.
- end_column: The end column of the area
- end_row: The end row of the area
- external_file_name: Get the external file name if this is an external reference
- is_area: Indicates whether this is an area
- is_external_link: Indicates whether this is an external link
- sheet_name: Indicates which sheet this reference is in
- start_column: The start column of the area
- start_row: The start row of the area
The sample code given below demonstrates the use of Name.get_referred_areas method to get Ranges with external links.