Copy Row Heights of Source Range to Destination Range
Contents
[
Hide
]
Sometime user needs to copy row heights of source range to destination range. Aspose.Cells for Python via .NET provides PasteType.ROW_HEIGHTS enum for this purpose. When you will set PasteOptions.paste_type property with PasteType.ROW_HEIGHTS enum then heights of all rows inside the source range will be copied to destination range.
The following sample code explains how to use PasteType.ROW_HEIGHTS enum to copy row heights of source range into destination range. Once you will open the output excel file generated by this code in Microsoft Excel, you will see that destination range row heights are exactly the same as source range row heights.
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
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) |