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

Question

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

score 27 · Accepted Answer · edited Oct 26 '15 at 15:44

27

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

edited Oct 26 '15 at 15:44

vahapt

1,685
1
21
26

answered Jul 14 '09 at 12:46

amischiefr

4,750
2
29
22

2

The int parameter in setRotation should be cast to short. – Giohji Aug 13 '13 at 20:17

score 2 · Answer 2 · answered Aug 12 '16 at 09:18

2

CellStyle cssVertical = wb.createCellStyle();
cssVertical.setFont(f);
cssVertical.setRotation((short)90);

answered Aug 12 '16 at 09:18

Ishan Liyanage

2,237
1
26
25

score 1 · Answer 3 · answered Sep 15 '20 at 07:56

XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet();
XSSFRow row = sheet.createRow(1);
XSSFCell cell = row.createCell(1);

XSSFCellStyle cs = workbook.createCellStyle();
cs.setRotation((short) 90);              // set text rotation
cs.getStyleXf().setApplyAlignment(true); // <<< Important

cell.setCellValue("Vertical Text");
cell.setCellStyle(cs);

workbook.write(new FileOutputStream("out.xlsx"));

Apache POI 3.17, need to manually add alignment="true" attribute in cellXfs section.

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

3 Answers3