Cell vertical top alignment using poi

Question

I am using POI api. Now my problem is that I am not able to align cell text vertically top.I am using getCellStyle().setAlignment(HSSFCellStyle.VERTICAL_TOP) to set alignment .

Yet when I open sheet it is not impacted.

score 29 · Answer 1 · edited Dec 12 '13 at 08:31

29

Had this problem as well, you will be supprised but to set vertical aligment to style in POI you should use setVerticalAlignment() function not setAlignment(). Example:

XSSFCellStyle styleSubHeader = (XSSFCellStyle) wb.createCellStyle();
styleSubHeader.setVerticalAlignment(CellStyle.VERTICAL_CENTER);

edited Dec 12 '13 at 08:31

bluish

26,356
27
122
180

answered Jan 11 '13 at 19:47

Vlad

1,077
8
8

score 12 · Answer 2 · answered Jun 16 '17 at 15:15

12

You can use this code :

style.setVerticalAlignment(VerticalAlignment.TOP);

answered Jun 16 '17 at 15:15

Jesús Sánchez

705
11
16

score 8 · Answer 3 · answered Jun 25 '18 at 14:29

8

this implementation

style.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP)

is deprecated, use :

org.apache.poi.ss.usermodel.CellStyle.setVerticalAlignment(VerticalAlignment.CENTER);

answered Jun 25 '18 at 14:29

Tiago Medici

1,944
22
22

Doesystem · Answer 4 · 2014-04-21T02:38:10.820

6

XSSFWorkbook wbOut = new XSSFWorkbook();    
CellStyle style = wbOut.createCellStyle();
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
cell.setCellStyle(style);

edited Apr 21 '14 at 02:38

answered Apr 21 '14 at 02:32

Doesystem

61
1
4

score -4 · Answer 5 · edited Oct 11 '12 at 00:59

-4

style = wb.createCellStyle();
style.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
cell = row.createCell((short) 2);
cell.setCellValue("X");
cell.setCellStyle(style);

edited Oct 11 '12 at 00:59

ASR

1,801
5
25
33

answered Jul 06 '12 at 12:50

Gaurav Rawal

1

Cell vertical top alignment using poi

5 Answers5