setRowHeights: Set worksheet row heights

In openxlsx: Read, Write and Edit xlsx Files

Set worksheet row heights

Description

Set worksheet row heights

Usage

setRowHeights(wb, sheet, rows, heights)

Arguments

wb	A workbook object
sheet	A name or index of a worksheet
rows	Indices of rows to set height
heights	Heights to set rows to specified in Excel column height units.

Author(s)

Alexander Walker

See Also

removeRowHeights()

Examples

## Create a new workbook
wb <- createWorkbook()

## Add a worksheet
addWorksheet(wb, "Sheet 1")

## set row heights
setRowHeights(wb, 1, rows = c(1, 4, 22, 2, 19), heights = c(24, 28, 32, 42, 33))

## overwrite row 1 height
setRowHeights(wb, 1, rows = 1, heights = 40)

## Save workbook
## Not run: 
saveWorkbook(wb, "setRowHeightsExample.xlsx", overwrite = TRUE)

## End(Not run)

openxlsx documentation built on Feb. 16, 2023, 6:47 p.m.