java - XSSF Apache POI -
i used below setting default column style in xssf sheet? not working can suggest bug fix.
format = workbook.createdataformat(); style = workbook.createcellstyle(); style.setdataformat(format.getformat("@")); sheet.setdefaultcolumnstyle(1, style);
probably this bug causing headaches. trying code apache poi 3.7 added effect second column gets hidden (width = 0) , format not applied.
cheers, wim
ps note talk second column, code referring to; if wanted apply style first column should have used 0 (zero-based).
Comments
Post a Comment