How To Set Excel Default Row Height in Apache POI

I recall having this problem, I just ended up with 1 of 2 approaches:

setting with width and height on individual cells to get around this problem. using an excel file as a template and writing to it.

Answers

Create a style with the desired height and apply it to the cells you want to appear that way. Documentation can help you. For a moment thought there was a method to set height thru styles...

Documentation for the method you ask... "set the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)". Must be sure to cast the input to Short

setDefaultRowHeight( (Short) 100)

Also can set height for a row with row.setHeight(Short)

Answers

I've posted this issue on Apache POI's issue tracker and someone confirmed that it's a bug.

https://issues.apache.org/bugzilla/show_bug.cgi?id=52626

It's fixed on revision r1243240