How To Set Excel Default Row Height in Apache POI

Question

I'm using Apache POI 3.7 with Spring MVC 3.1.

How to set excel default row height in apache POI?

I've tried sheet.setDefaultRowHeight((short) 100) and sheet.setDefaultRowHeightInPoints(100)

but that doesn't work.

Any suggestion for this problem?

Thank you.

Answer 1

I use

    row.setHeightInPoints((2 * sheet.getDefaultRowHeightInPoints()));

to set it (for example) to 2 characters high.