POI 自定义16进制颜色导出

今天导入一个Excel 要求什么格式导入就怎么显示，包括字体 颜色，还要怎么导出。这个poi导入的是16进制颜色，导出比较麻烦。具体参考以下代码吧

    private CellStyle createStyle(Workbook wb, ExcelCellStyle excelCellStyle) {        if(styleMap.get(excelCellStyle.getBgColor())!=null)            return styleMap.get(excelCellStyle.getBgColor());        CellStyle style = wb.createCellStyle();        Font titleFont = wb.createFont();        //titleFont.setFontHeightInPoints((short)48);        //titleFont.setColor(IndexedColors.DARK_BLUE.getIndex());        style = wb.createCellStyle();        String colorStr = excelCellStyle.getBgColor();        if (colorStr.length() > 6)            colorStr = colorStr.substring(2);        HSSFPalette palette = ((HSSFWorkbook) wb).getCustomPalette();//replacing the standard red with freebsd.org red        palette.setColorAtIndex((short) 9,                (byte) convertHexToNumber(colorStr.substring(0, 2)),//RGB red                (byte) convertHexToNumber(colorStr.substring(2, 4)),//RGB green                (byte) convertHexToNumber(colorStr.substring(4, 6)) //RGB blue        );        style.setFillForegroundColor((short) 9);        style.setFillPattern((short) 1);        //style.setVerticalAlignment(VerticalAlignment.CENTER);        style.setFont(titleFont);        styleMap.put(excelCellStyle.getBgColor(), style);        return style;    }    private int convertHexToNumber(String hex) {        int num = 0;        try {            num = Integer.parseInt(hex, 16);        } catch (Throwable t) {            logger.error("数字转换异常 " + t);        }        return num;    }