获取带有外部链接的范围
Contents
[
Hide
]
获取带有外部链接的范围
许多时候,Excel文件通过外部链接访问其他Excel文件中的数据。Aspose.Cells for Python via .NET提供了使用Name.get_referred_areas方法检索这些外部链接的选项。Name.get_referred_areas方法返回类型为ReferredArea的数组。ReferredArea类提供了external_file_name属性,返回外部文件的名称。ReferredArea类公开了以下成员。
- end_column:区域的结束列
- end_row:区域的结束行
- external_file_name:如果这是外部引用,获取外部文件名
- is_area: 表示这是否为一个区域
- is_external_link: 表示这是否为外部链接
- sheet_name: 表示此引用所在的工作表
- start_column: 区域的起始列
- start_row: 区域的起始行
下面给出的示例代码演示了使用 Name.get_referred_areas 方法获取带有外部链接的范围。
示例代码
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Source directory | |
sourceDir = RunExamples.Get_SourceDirectory() | |
# Load source Excel file | |
workbook = Workbook(sourceDir + "SampleExternalReferences.xlsx") | |
for namedRange in workbook.worksheets.names: | |
referredAreas = namedRange.get_referred_areas(True) | |
if referredAreas != None: | |
for i in range(len(referredAreas)): | |
referredArea = referredAreas[i] | |
# Print the data in Referred Area | |
print("IsExternalLink: " + str(referredArea.is_external_link)) | |
print("IsArea: " + str(referredArea.is_area)) | |
print("SheetName: " + referredArea.sheet_name) | |
print("ExternalFileName: " + referredArea.external_file_name) | |
print("StartColumn: " + str(referredArea.start_column)) | |
print("StartRow: " + str(referredArea.start_row)) | |
print("EndColumn: " + str(referredArea.end_column)) | |
print("EndRow: " + str(referredArea.end_row)) |