search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
364 stars 79 forks source link

setColWidths: "auto" based on all rows #537

Open stellathecat opened 2 years ago

stellathecat commented 2 years ago

setColWidths(wb, sheet = 1, cols = 1, widths = "auto")

sets the width based on the string in the first row of column 1 whereas Excel would use the maximum width of strings in all rows of column 1

would be great to have this option too

ycphs commented 2 years ago

Could you please create an issue at ycphs/openxlsx?

This is the active fork of the package.