POI IndexedColors 颜色对照预览 SXSSFWorkbook

最新推荐文章于 2024-09-23 15:50:28 发布

NIYUEKE

最新推荐文章于 2024-09-23 15:50:28 发布

阅读量5.4k

点赞数 18

文章标签： java poi

本文链接：https://blog.csdn.net/ZhangHK_GG/article/details/121101398

版权

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 color