获取带有外部链接的范围
Contents
[
Hide
]
获取带有外部链接的范围
许多时候,Excel文件通过外部链接访问其他Excel文件的数据。 Aspose.Cells 提供了通过使用 Name.GetReferredAreas 方法来检索这些外部链接的选项。Name.GetReferredAreas 方法返回 ReferredArea 类型的数组。ReferredArea 类提供了 ExternalFileName 属性,返回外部文件的名称。ReferredArea 类公开了以下成员。
- EndColumn:区域的结束列
- EndRow:区域的结束行
- ExternalFileName:如果这是外部引用,获取外部文件名
- IsArea: 表示这是否为一个区域
- IsExternalLink: 表示这是否为外部链接
- SheetName: 表示此引用所在的工作表
- StartColumn: 区域的起始列
- StartRow: 区域的起始行
下面给出的示例代码演示了使用 Name.GetReferredAreas 方法来获取带有外部链接的范围。
示例代码
This file contains 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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
// Instantiate a Workbook object and Open an Excel file | |
Workbook workbook = new Workbook(sourceDir + "SampleExternalReferences.xlsx"); | |
Name namedRange = workbook.getWorksheets().getNames().get("Names"); | |
// Get ReferredAreas | |
ReferredArea[] referredAreas = namedRange.getReferredAreas(true); | |
if (referredAreas != null) { | |
for (int i = 0; i < referredAreas.length; i++) { | |
ReferredArea referredArea = referredAreas[i]; | |
// Print the data in Referred Area | |
System.out.println("IsExternalLink: " + referredArea.isExternalLink()); | |
System.out.println("IsArea: " + referredArea.isArea()); | |
System.out.println("SheetName: " + referredArea.getSheetName()); | |
System.out.println("ExternalFileName: " + referredArea.getExternalFileName()); | |
System.out.println("StartColumn: " + referredArea.getStartColumn()); | |
System.out.println("StartRow: " + referredArea.getStartRow()); | |
System.out.println("EndColumn: " + referredArea.getEndColumn()); | |
System.out.println("EndRow: " + referredArea.getEndRow()); | |
} | |
} |