Remove column widths from a worksheet
Remove column widths from a worksheet
removeColWidths(wb, sheet, cols)
wb |
A workbook object |
sheet |
A name or index of a worksheet |
cols |
Indices of columns to remove custom width (if any) from. |
Alexander Walker
## Create a new workbook
wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx"))
## remove column widths in columns 1 to 20
removeColWidths(wb, 1, cols = 1:20)
## Not run:
saveWorkbook(wb, "removeColWidthsExample.xlsx", overwrite = TRUE)
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.