Current location - Loan Platform Complete Network - Big data management - java set export Excel, a cell has a part of the font color to change to red
java set export Excel, a cell has a part of the font color to change to red
// Rise and 56 entered as two static objects

Label label = null;

jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.createFont(cell .getCellFormat().getFont().getName()), cell.getCellFormat().getFont().getPointSize(),

WritableFont.NO_BOLD, false,

UnderlineStyle.NO_UNDERLINE);

jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);

wcfFC. setAlignment(jxl.format.Alignment.CENTRE);//set cell centered

if(cell.getContents().toString().equals("56"){

label = new Label(cell .getColumn(), cell.getRow(), cell.getContents());

}else{

label = new Label(cell.getColumn(), cell.getRow(), cell.getContents( ),wcfFC);

}