Image

Imagepenguin001 wrote in Imagejava_dev 🤔curious

Sizing up HSSFCell

I'm working on a project in which I'm using org.apache.poi.hssf.usermodel.HSSFWorkBook (and all it's associates such as HSSFCell) in order to output to an excel file.

I'm not having any problems getting it to the sheet, but rather I'm very unhappy about the size of the cells. Some of them contain data that's around 50 characters, yet only are wide enough to display 30 of them. Does anybody know how to make a cell (and therefor the column) as wide as it needs to be to display the information in it?

x-posted to Imagedevelopers