Set worksheet row heights

Share:

Description

Set worksheet row heights

Usage

1
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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
## 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
saveWorkbook(wb, "setRowHeightsExample.xlsx", overwrite = TRUE)

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.