创建联合范围
Contents
[
Hide
]
创建联合范围
Aspose.Cells 提供了使用 WorksheetCollection.CreateUnionRange 方法创建联合范围的功能。WorksheetCollection.CreateUnionRange 方法接受两个参数,用于创建联合范围的地址和工作表的索引。WorksheetCollection.CreateUnionRange 方法返回一个 UnionRange 对象。
以下代码片段演示了如何使用 WorksheetCollection.CreateUnionRange 方法创建联合范围。代码生成的输出文件附在下面供参考。
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
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Create union range | |
UnionRange unionRange = workbook.Worksheets.CreateUnionRange("sheet1!A1:A10,sheet1!C1:C10", 0); | |
// Put value "ABCD" in the range | |
unionRange.Value = "ABCD"; | |
// Save the output workbook. | |
workbook.Save("CreateUnionRange_out.xlsx"); |