实现非连续范围
Contents
[
Hide
]
通常,命名范围 是具有连续和相邻单元格的矩形。但有时,您可能需要使用非连续的单元格范围,即单元格不相邻。Aspose.Cells 支持创建具有非相邻单元格的命名范围。为此,API 提供了 Name.RefersTo 属性。
实现非连续范围的 Java 代码
以下代码示例展示了如何使用Aspose.Cells for Java创建一个命名的非连续范围。
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 | |
// The path to the documents directory. | |
String dataDir = Utils.getDataDir(ImplementingNonSequentialRanges.class); | |
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Adding a Name for non sequenced range | |
int index = workbook.getWorksheets().getNames().add("NonSequencedRange"); | |
Name name = workbook.getWorksheets().getNames().get(index); | |
// Creating a non sequence range of cells | |
name.setRefersTo("=Sheet1!$A$1:$B$3,Sheet1!$D$5:$E$6"); | |
// Save the workbook | |
workbook.save(dataDir + "dest.xls"); |