How to rotate text in a spreadsheet cell using Apache POI?

apache, api, excel, java, spreadsheet

Solution

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);

Problem

How can I rotate the text within an HSSFCell class of Apache POI?

Original source