POI IndexedColors 颜色对照预览 SXSSFWorkbook

POI  IndexedColors 颜色对照预览 SXSSFWorkbook

<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.9</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi</artifactId>
	<version>3.9</version>
</dependency>
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml-schemas</artifactId>
	<version>3.9</version>
</dependency>

import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;


public class POIColorPreview {

    public static void main(String[] args) {
        SXSSFWorkbook workbook = new SXSSFWorkbook();
        Sheet sheet = workbook.createSheet();

        // 字体
        Font font = workbook.createFont();
        font.setColor(HSSFColor.WHITE.index);

        int rownum = 0;
        int column = 0;
        Row row = sheet.createRow(rownum);
        sheet.setColumnWidth(rownum, 6000);// 设置列宽
        for (IndexedColors colors : IndexedColors.values()) {
            // 为了方便查看,做个换行处理
            if (column > 5) {
                rownum++;
                column = 0;
                row = sheet.createRow(rownum);
                sheet.setColumnWidth(rownum, 6000);
            }
            CellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setFillForegroundColor(colors.getIndex());
            cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
            cellStyle.setFont(font);

            Cell cell = row.createCell(column);
            cell.setCellValue(colors.toString());
            cell.setCellStyle(cellStyle);
            column++;
        }
        // 写文件
        try (FileOutputStream outputStream = new FileOutputStream(new File("D:\\POI.xlsx"))) {
            workbook.write(outputStream);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

BLACK	WHITE	RED	BRIGHT_GREEN	BLUE	YELLOW
PINK	TURQUOISE	DARK_RED	GREEN	DARK_BLUE	DARK_YELLOW
VIOLET	TEAL	GREY_25_PERCENT	GREY_50_PERCENT	CORNFLOWER_BLUE	MAROON
LEMON_CHIFFON	ORCHID	CORAL	ROYAL_BLUE	LIGHT_CORNFLOWER_BLUE	SKY_BLUE
LIGHT_TURQUOISE	LIGHT_GREEN	LIGHT_YELLOW	PALE_BLUE	ROSE	LAVENDER
TAN	LIGHT_BLUE	AQUA	LIME	GOLD	LIGHT_ORANGE
ORANGE	BLUE_GREY	GREY_40_PERCENT	DARK_TEAL	SEA_GREEN	DARK_GREEN
OLIVE_GREEN	BROWN	PLUM	INDIGO	GREY_80_PERCENT	AUTOMATIC