Learn R Programming

openxlsx (version 1.0.3)

removeRowHeights: Remove custom row heights from a worksheet

Description

Remove custom row heights from a worksheet

Usage

removeRowHeights(wb, sheet, rows)

Arguments

wb
A workbook object
sheet
A name or index of a worksheet
rows
Indices of rows to remove custom height (if any) from.

See Also

setRowHeights

Examples

Run this code
## Create a new workbook
wb <- loadWorkbook(xlsxFile = file.path(path.package("openxlsx"), "loadExample.xlsx"))

## remove any custom row heights in rows 1 to 10
removeRowHeights(wb, 1, rows = 1:10)
saveWorkbook(wb, "removeRowHeightsExample.xlsx", overwrite = TRUE)

Run the code above in your browser using DataLab