将源范围行高度复制到目标范围
Contents
[
Hide
]
有时用户需要将源范围的行高度复制到目标范围。Aspose.Cells 提供了 PasteType.ROW_HEIGHTS 枚举来实现这一目的。当您将 PasteOptions.setPasteType() 属性设置为 PasteType.ROW_HEIGHTS 枚举时,源范围内所有行的高度将被复制到目标范围。
将源范围的行高复制到目标范围
以下示例代码解释了如何使用 PasteType.ROW_HEIGHTS 枚举将源范围的行高度复制到目标范围。一旦您在 Microsoft Excel 中打开此代码生成的输出 Excel 文件,您会发现目标范围的行高度与源范围的行高度完全相同。
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(CopyRowHeights.class); | |
// Create workbook object | |
Workbook workbook = new Workbook(); | |
// Source worksheet | |
Worksheet srcSheet = workbook.getWorksheets().get(0); | |
// Add destination worksheet | |
Worksheet dstSheet = workbook.getWorksheets().add("Destination Sheet"); | |
// Set the row height of the 4th row | |
// This row height will be copied to destination range | |
srcSheet.getCells().setRowHeight(3, 50); | |
// Create source range to be copied | |
Range srcRange = srcSheet.getCells().createRange("A1:D10"); | |
// Create destination range in destination worksheet | |
Range dstRange = dstSheet.getCells().createRange("A1:D10"); | |
// PasteOptions, we want to copy row heights of source range to destination range | |
PasteOptions opts = new PasteOptions(); | |
opts.setPasteType(PasteType.ROW_HEIGHTS); | |
// Copy source range to destination range with paste options | |
dstRange.copy(srcRange, opts); | |
// Write informative message in cell D4 of destination worksheet | |
dstSheet.getCells().get("D4").putValue("Row heights of source range copied to destination range"); | |
// Save the workbook in xlsx format | |
workbook.save(dataDir + "output.xlsx", SaveFormat.XLSX); |