How to set Cell Format using Apache POI?

Asked Jun 07 '22 at 04:44

Active Jun 07 '22 at 06:17

Viewed 37 times

can i set the format in cell using apache poi? i was trying with this code :

HSSFSheet sheet = workbook.createSheet("test");

HSSFRow row = sheet.createRow(0);
Cell c = row.createCell(0);
c.setCellType(CellType.NUMERIC);
c.setCellValue(111);

and I was trying with this code from this link : Number and cell Formatting in apache poi

but it does not work. it is still in GENERAL Format. I want it change to NUMBER

enter image description here

edited Jun 07 '22 at 06:17

asked Jun 07 '22 at 04:44

Sekti Andarbeni

Cell type is independent of cell format. – Jim Garrison Jun 07 '22 at 04:58
so it is impossible to set it automatically using POI or anything? @JimGarrison – Sekti Andarbeni Jun 07 '22 at 05:38
What you have marked in the screen shot is the **format**, not the type. The default Number format would be the built in format 2: `style.setDataFormat((short)0x2);` or 1: `style.setDataFormat((short)0x1);`. – Axel Richter Jun 07 '22 at 05:56
Thanks @AxelRichter , it is so help me – Sekti Andarbeni Jun 07 '22 at 06:25

How to set Cell Format using Apache POI?

0 Answers0