java - Auto size height for rows in Apache POI

Question

I am inputting values into a spreadsheet using Apache POI. These values have newlines, and I was able to use this code successfully:

CellStyle style = cell.getCellStyle()
style.setWrapText(true)
cell.setCellStyle(style)

Unfortunately, while the text is wrapping correctly, the rows are not always growing in height enough to show the content. How do I ensure that my rows are always the correct height?

question from:https://stackoverflow.com/questions/19145628/auto-size-height-for-rows-in-apache-poi

Answer 1

currentRow.setHeight((short)-1)

Works for XSSFCell and Excel 2013