Hello, i am trying set my cells to this date format "20.12.08". It's predefined format in excel 2003, when i use it in excel and set output to xml i see that format is stored as: <Style ss:ID="s22"> <NumberFormat ss:Format="dd/mm/yy;@"/> </Style>
When i read this made in excel cell with HSSF and use this method: cell.getCellStyle().getDataFormat() i get number 172 in dec. I try set this format by using HSSFDataFormat.getBuiltinFormat but there is "only" 50 formats and i think my dd/mm/yy isn't there. Can anybody help me how set this format when i am generating excel file using HSSF classes? Thank a lot, Jakub.
