Implementing Non-Sequential Ranges
Contents
[
Hide
]
Possible Usage Scenarios
Normally, named ranges are rectangular with cells continuous and adjacent to each other. But sometimes, you may need to use a non-sequential cell range in which cells are not adjacent. Aspose.Cells for Python via .NET supports creating a named range with non-adjacent cells.
How to Add Non-Sequential Ranges Using Aspose.Cells for Python Excel Library
The code sample below shows how to create a named non-sequential range with Aspose.Cells for Python via .NET.
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
| from aspose.cells import Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Instantiating a Workbook object | |
| workbook = Workbook() | |
| # Adding a Name for non sequenced range | |
| index = workbook.worksheets.names.add("NonSequencedRange") | |
| name = workbook.worksheets.names[index] | |
| # Creating a non sequence range of cells | |
| name.refers_to = "=Sheet1!$A$1:$B$3,Sheet1!$E$5:$D$6" | |
| # Save the workbook | |
| workbook.save(dataDir + "Output.out.xlsx") |