public static void setFontColor(Worksheet sheet, int row, int col, String color){
final Cell cell = Utils.getOrCreateCell(sheet,row,col);
final Book book = (Book) sheet.getWorkbook();
final short fontIdx = cell.getCellStyle().getFontIndex();
final Font font = book.getFontAt(fontIdx);
final Color orgColor = BookHelper.getFontColor(book, font);
final Color newColor = BookHelper.HTMLToColor(book, color);
if (orgColor == newColor || orgColor != null && orgColor.equals(newColor)) {
return;
}
final short boldWeight = font.getBoldweight();
final short fontHeight = font.getFontHeight();
final String name = font.getFontName();
final boolean italic = font.getItalic();
final boolean strikeout = font.getStrikeout();
final short typeOffset = font.getTypeOffset();
final byte underline = font.getUnderline();
final Font newFont = BookHelper.getOrCreateFont(book, boldWeight, newColor, fontHeight, name, italic, strikeout, typeOffset, underline);
final CellStyle style = cloneCellStyle(cell);
style.setFont(newFont);
cell.setCellStyle(style);
}