Set worksheet row heights
Set worksheet row heights
setRowHeights(wb, sheet, rows, heights)
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. |
Alexander Walker
## 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)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.