Copy Row Heights of Source Range to Destination Range with Node.js via C++

Sometimes users need to copy row heights of a source range to a destination range. Aspose.Cells for Node.js via C++ provides PasteType.RowHeights enum for this purpose. When you set the PasteOptions.getPasteType() property with PasteType.RowHeights, the heights of all rows inside the source range will be copied to the destination range.

The following sample code explains how to use PasteType.RowHeights enum to copy row heights of the source range into the destination range. Once you 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 the source range row heights.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Create workbook object
const workbook = new AsposeCells.Workbook();

// Source worksheet
const srcSheet = workbook.getWorksheets().get(0);

// Add destination worksheet
const 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
const srcRange = srcSheet.getCells().createRange("A1:D10");

// Create destination range in destination worksheet
const dstRange = dstSheet.getCells().createRange("A1:D10");

// PasteOptions, we want to copy row heights of source range to destination range
const opts = new AsposeCells.PasteOptions();
opts.setPasteType(AsposeCells.PasteType.RowHeights);

// 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(path.join(dataDir, "output_out.xlsx"), AsposeCells.SaveFormat.Xlsx);