redcellprocessor2.java

一个java生成自动生成Excel

package net.sf.jxls.sample;

import java.util.HashMap;
import java.util.Map;

import net.sf.jxls.parser.Cell;
import net.sf.jxls.parser.Expression;
import net.sf.jxls.parser.Property;
import net.sf.jxls.processor.CellProcessor;
import net.sf.jxls.sample.model.Employee;
import net.sf.jxls.util.Util;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.util.HSSFColor;

/**
 * WARNING! This class does not work since 0.8.7 jXLS release as there were changes in expression parsing introduced
 * for full JEXL support.
 * If you need to apply conditional formatting to some cells or row you may use jx:if tag.
 * @deprecated
 * @author Leonid Vysochyn
 */
public class RedCellProcessor2  implements CellProcessor {

    static HSSFCellStyle hssfCellStyle;
    String beanName;

    Map rowStyles = new HashMap();

    public RedCellProcessor2(String collectionName) {
        this.beanName = collectionName.replace('.', '_');
    }

    public void processCell(final Cell cell, final Map namedCells) {
        if( cell.getExpressions().size()>0 ){
            Expression expression = (Expression) cell.getExpressions().get(0);
            Property property = (Property)expression.getProperties().get(0);
            if (property != null && property.getBeanName() != null && property.getBeanName().indexOf(beanName) >= 0 && property.getBean() instanceof Employee) {
                Employee employee = (Employee) property.getBean();
                if (employee.getPayment().doubleValue() >= 2000) {
                        HSSFCell hssfCell = cell.getHssfCell();
                        HSSFCellStyle newStyle = duplicateStyle( cell, property.getPropertyNameAfterLastDot() );
                        newStyle.setFillForegroundColor( HSSFColor.RED.index );
                        newStyle.setFillPattern( HSSFCellStyle.SOLID_FOREGROUND );
                        hssfCell.setCellStyle( newStyle );
                }
            }
        }
    }

    HSSFCellStyle duplicateStyle( Cell cell, String key ){
        if( rowStyles.containsKey( key ) ){
            return (HSSFCellStyle) rowStyles.get( key );
        }
        HSSFCellStyle newStyle =  Util.duplicateStyle( cell.getRow().getSheet().getHssfWorkbook(), cell.getHssfCell().getCellStyle() );
        rowStyles.put( key, newStyle );
        return newStyle;
    }

}