将源范围的行高复制到目标范围

有时用户需要将源范围的行高复制到目标范围。 Aspose.Cells提供粘贴类型.ROW_HEIGHTS枚举用于此目的。什么时候设置粘贴选项.setPasteType()财产与粘贴类型.ROW_HEIGHTS枚举然后源范围内所有行的高度将被复制到目标范围。

下面的示例代码解释了如何使用粘贴类型.ROW_HEIGHTS用于将源范围的行高复制到目标范围的枚举。在 Microsoft Excel 中打开此代码生成的输出 Excel 文件后，您将看到目标范围行高与源范围行高完全相同。

	// 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);