JXLS生成excel并自定義單元格樣式

　　　本人最近需要每天統計資料表，并每周一發送統計結果的郵件，是以寫了個springboot老自動完成工作。項目位址為：https://github.com/707293891/springboot

　　　其中某些統計資料需要特殊标記：紅色顯示。

　　　如圖：模版如下

　　　但是需要在某一處特殊顯示為紅色：如圖

　　　

　　   現在寫出實作過程：

　　　利用jxls的區域監聽器實作.

　　　　

Transformer transformer = TransformerFactory.createTransformer(getFileInputStream(),
                new FileOutputStream(
                        new File(
                                Thread.currentThread().getContextClassLoader().
                                        getResource("excelTemplates/result").getFile()+"/result.xls")));
        XlsArea xlsArea=new XlsArea("Sheet1!A1:F3",transformer);
        XlsArea employeeArea = new XlsArea("Sheet1!A3:F3", transformer);
        employeeArea.addAreaListener(new SimpleAreaListener(employeeArea));
        EachCommand eachCommand=new EachCommand("item","items",employeeArea);
        xlsArea.addCommand("A3:F3", eachCommand);
        Context context = new Context();
        Map map=new HashMap();
        // map.put("list",getData());
        map.put("week",CalendarUtil.getWeekNum());
        map.put("month",CalendarUtil.getMonth());
        context.putVar("print", map);
        context.putVar("items",list);
        xlsArea.applyAt(new CellRef("Sheet1!A1"), context);
        transformer.write();      

　　SimpleAreaListener實作如下：
　　      

package com.yinhai.yunwei.excel;

import com.yinhai.yunwei.yunwei.mapper.YunweiInfo;
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.Workbook;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.jxls.area.Area;
import org.jxls.area.XlsArea;
import org.jxls.common.AreaListener;
import org.jxls.common.CellRef;
import org.jxls.common.Context;
import org.jxls.transform.poi.PoiTransformer;

import java.util.Map;

/**
 * @author 範超
 * @version V1.0
 * @Title SimpleAreaListener
 * @Package jxls
 * @Descript :TODO()
 * @date : 2018/6/25  上午10:22
 */
public class SimpleAreaListener implements AreaListener {
    private Area area;
    PoiTransformer transformer;
    public SimpleAreaListener(XlsArea xlsArea) {
        this.area=xlsArea;
        transformer= (PoiTransformer) xlsArea.getTransformer();
    }

    @Override
    public void beforeApplyAtCell(CellRef cellRef, Context context) {

    }

    @Override
    public void afterApplyAtCell(CellRef cellRef, Context context) {
    }

    @Override
    public void beforeTransformCell(CellRef cellRef, CellRef cellRef1, Context context) {

    }

    @Override
    public void afterTransformCell(CellRef cellRef, CellRef cellRef1, Context context) {
        if (cellRef1.getCol()!=3&&cellRef1.getCol()!=5){
            return;
        }
        Workbook workbook=transformer.getWorkbook();
        Cell cell=workbook.getSheet(cellRef1.getSheetName()).getRow(cellRef1.getRow()).getCell(cellRef1.getCol());
        CellStyle cellStyle=cell.getCellStyle();
        Font font=workbook.createFont();
        CellStyle resultCell=workbook.createCellStyle();
        Object item=context.getVar("item");
//需要顯示紅色的條件
        if(item!=null&&item instanceof YunweiInfo &&"****".equals(((YunweiInfo) item).getName())){
            font.setColor(XSSFFont.COLOR_RED);
            resultCell.setFont(font);
            cell.setCellStyle(resultCell);
        }
    }

}      

　　　　這樣當滿足條件時就會實作特殊的顯示格式了。

　　　　其中jxls版本為如下

　　　　

<dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls</artifactId>
            <version>[2.4.3,)</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-poi</artifactId>
            <version>[1.0.14,)</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-jexcel</artifactId>
            <version>[1.0.6,)</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-reader</artifactId>
            <version>[2.0.3,)</version>
        </dependency>