获取带有外部链接的范围
Contents
[
Hide
]
获取带有外部链接的范围
访问外部链接
- 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-.NET | |
//Source directory | |
string sourceDir = RunExamples.Get_SourceDirectory(); | |
//Load source Excel file | |
Workbook workbook = new Workbook(sourceDir + "SampleExternalReferences.xlsx"); | |
foreach (Name namedRange in workbook.Worksheets.Names) | |
{ | |
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 | |
Console.WriteLine("IsExternalLink: " + referredArea.IsExternalLink); | |
Console.WriteLine("IsArea: " + referredArea.IsArea); | |
Console.WriteLine("SheetName: " + referredArea.SheetName); | |
Console.WriteLine("ExternalFileName: " + referredArea.ExternalFileName); | |
Console.WriteLine("StartColumn: " + referredArea.StartColumn); | |
Console.WriteLine("StartRow: " + referredArea.StartRow); | |
Console.WriteLine("EndColumn: " + referredArea.EndColumn); | |
Console.WriteLine("EndRow: " + referredArea.EndRow); | |
} | |
} | |
} |