使用外部链接获取范围

在许多情况下，excel 文件通过使用外部链接从其他 excel 文件访问数据。 Aspose.Cells for Python via Java 提供了通过使用检索这些外部链接的选项[名称.GetReferredAreas](https://reference.aspose.com/cells/python/asposecells.api/name#getReferredAreas(boolean)）方法。这名称.GetReferredAreas 方法返回类型数组推荐区域.这推荐区域类提供了一个外部文件名返回外部文件名称的属性。

以下代码片段显示了如何获取外部链接。

	source_directory = "Examples/SampleFiles/SourceDirectory/"

	# Load Source Excel file
	workbook = Workbook(source_directory + "SampleExternalReferences.xlsx")

	namedRange = workbook.getWorksheets().getNames().get("Names")

	# Get ReferredAreas
	referredAreas = namedRange.getReferredAreas(True)

	if referredAreas != None:
	for referredArea in referredAreas:
	# Print the data in Referred Area
	print("IsExternalLink: " + str(referredArea.isExternalLink()))
	print("IsArea: " + str(referredArea.isArea()))
	print("SheetName: " + referredArea.getSheetName())
	print("ExternalFileName: " + referredArea.getExternalFileName())
	print("StartColumn: " + str(referredArea.getStartColumn()))
	print("StartRow: " + str(referredArea.getStartRow()))
	print("EndColumn: " + str(referredArea.getEndColumn()))
	print("EndRow: " + str(referredArea.getEndRow()))