Remove row heights from a worksheet
removeRowHeights(wb, sheet, rows)
wb | A workbook object |
---|---|
sheet | A name or index of a worksheet |
rows | Indices of rows to remove custom height (if any) from. |
Alexander Walker
## Create a new workbook wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx")) ## remove any custom row heights in rows 1 to 10 removeRowHeights(wb, 1, rows = 1:10) if (FALSE) { saveWorkbook(wb, "removeRowHeightsExample.xlsx", overwrite = TRUE) }