Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

setRowHeights

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

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

Read, Write and Edit xlsx Files

v4.2.3
MIT + file LICENSE
Authors
Philipp Schauberger [aut, cre], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb]
Initial release
2020-10-26

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.