Garudadwajan Garudadwajan - 3 months ago 13
Apache Configuration Question

how to rotate text in HSSFCell in apache POI?

How to rotate text which is there in HSSFCell class of Apache POI API?

Can you please provide some example code for the same?

Answer

Use HSSFCellStyle, that class has a method called setRotation(short rotation) which will rotate the text. All you do is apply the cell style to a cell:

HSSFCellStyle myStyle = workbook.createCellStyle();
myStyle.setRotation((short)90);

HSSFCell c = row.createCell(columnNumber);
c.setCellStyle(myStyle);