java excel 颜色_Java POI 实现Excel相同数据同一颜色，不同数据颜色交替显示

1、效果图

2、具体代码实现

excel 读取工具类

package utils;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

import org.apache.log4j.Logger;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**

* excel读写工具类 */

public class POIUtil2 {

private static Logger logger = Logger.getLogger(POIUtil2.class);

private final static String xls = "xls";

private final static String xlsx = "xlsx";

/**

* 读入excel文件，解析后返回

* @param file

* @throws IOException

*/

public static List readExcel(File file) throws IOException{

//检查文件

checkFile(file);

//获得Workbook工作薄对象

Workbook workbook = getWorkBook(file);

//创建返回对象，把每行中的值作为一个数组，所有行作为一个集合返回

List list = new ArrayList();

if(workbook != null){

for(int sheetNum = 0;sheetNum < workbook.getNumberOfSheets();sheetNum++){

//获得当前sheet工作表

Sheet sheet = workbook.getSheetAt(sheetNum);

if(sheet == null){

continue;

}

//获得当前sheet的开始行

int firstRowNum = sheet.getFirstRowNum();

//获得当前sheet的结束行

int lastRowNum = sheet.getLastRowNum();

//循环除了第一行的所有行

// for(int rowNum = firstRowNum+1;rowNum <= lastRowNum;rowNum++){

for(int rowNum = firstRowNum;rowNum <= lastRowNum;rowNum++){<