Remove column widths from a worksheet

Source: R/wrappers.R

Remove column widths from a worksheet

removeColWidths(wb, sheet, cols)

Arguments

wb

A workbook object
sheet

A name or index of a worksheet
cols

Indices of columns to remove custom width (if any) from.

See also

setColWidths

Author

Alexander Walker

Examples

## 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)
if (FALSE) {
saveWorkbook(wb, "removeColWidthsExample.xlsx", overwrite = TRUE)
}