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

有时用户需要将源范围的行高度复制到目标范围。Aspose.Cells for Python via .NET提供了此目的的PasteType.ROW_HEIGHTS枚举。当您使用PasteType.ROW_HEIGHTS枚举设置PasteOptions.paste_type属性时，源范围内所有行的高度将被复制到目标范围。

以下示例代码说明了如何使用PasteType.ROW_HEIGHTS枚举将源范围的行高复制到目标范围。一旦您在Microsoft Excel中打开由此代码生成的输出excel文件，您将看到目标范围的行高与源范围的行高完全相同。

from aspose.cells import PasteOptions, PasteType, SaveFormat, 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(".")
#  Create workbook object
workbook = Workbook()
#  Source worksheet
srcSheet = workbook.worksheets[0]
#  Add destination worksheet
dstSheet = workbook.worksheets.add("Destination Sheet")
#  Set the row height of the 4th row. This row height will be copied to destination range
srcSheet.cells.set_row_height(3, 50)
#  Create source range to be copied
srcRange = srcSheet.cells.create_range("A1:D10")
#  Create destination range in destination worksheet
dstRange = dstSheet.cells.create_range("A1:D10")
#  PasteOptions, we want to copy row heights of source range to destination range
opts = PasteOptions()
opts.paste_type = 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.cells.get("D4").put_value("Row heights of source range copied to destination range")
#  Save the workbook in xlsx format
workbook.save(dataDir + "output_out.xlsx", SaveFormat.XLSX)