excel 单元格背景色, 如何通过POI自定义

通过POI自定义单元格背景色

XSSFCellStyle

XSSFCellStyle.setFillForegroundColor(new XSSFColor( new java.awt.Color(r, g, b)));

HSSFCellStyle

HSSFWorkbook workbook;
HSSFPalette palette = workbook.getCustomPalette();
palette.setColorAtIndex(HSSFColor.HSSFColorPredefined.**.getIndex(), r, g,b);
HSSFCellStyle.setFillForegroundColor(HSSFColor.HSSFColorPredefined.**.getIndex());