changing the color of excel font poi

(Last Updated On: June 7, 2013)

changing the color of excel font poi:

Apache poi is used to create the excel sheet in java and it provides lot of features such as autosize to column or header or contents etc…

Along with those options you can change the font color in the excel using apache poi in java,

HSSFFont font = wb.createFont();
HSSFCellStyle style = wb.createCellStyle();
style.setFont(font);
font = wb.createFont();
font.setColor(HSSFColor.WHITE.index);
style = wb.createCellStyle();
style.setFont(font);

 

Now the font color will be changed to white from black. Using apache poi you can also change background color, font family, autosize, setcolumnwidth etc…

 

171 total views, 0 views today

Leave a Reply

Your email address will not be published. Required fields are marked *