Skapa Union Range
Contents
[
Hide
]
Skapa unionsspann
Aspose.Cells ger möjlighet att skapa en Union Range genom att använda metoden WorksheetCollection.CreateUnionRange. Metoden WorksheetCollection.CreateUnionRange accepterar två parametrar, adressen för att skapa unionrådet och arbetsbladets index. Metoden WorksheetCollection.CreateUnionRange returnerar ett objekt UnionRange.
Följande kodsnutt visar hur man skapar en Union Range genom att använda metoden WorksheetCollection.CreateUnionRange. Den resulterande filen som genereras av koden bifogas som referens.
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"); |