ExcelConfig.java 2.97 KB
package com.cjs.cms.util.poi;

import java.io.File;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.List;

/**
 * ExcelWrite导出配置(ExcelWriteUtil)
 * 
 * @author trunks
 * 
 */
public class ExcelConfig {

    private File       sourceTemplate;                                           // 模板文件路径
    private File       targetFile;                                               // 生成的文件路径
    private Integer    pageSize;                                                 // 每页行数
    private DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // 日期格式化
    private List<?>    data;                                                     // 写入excel的数据
    private String[]   autoSizeColumn;                                           // 自适应列(属性名集合)
    private Boolean    autoSize   = false;                                       // 自适应所有列
    private String[]   sumColumn;                                                // 汇总列(属性名集合)
    private Integer    flushSize  = 500;                                         // 每写入指定行刷新一次,默认500。如果依然内存溢出,可考虑缩小此值。
    private String     remark1;                                                  //盛付通批次号

    public ExcelConfig() {
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }

    public DateFormat getDateFormat() {
        return dateFormat;
    }

    public void setDateFormat(DateFormat dateFormat) {
        this.dateFormat = dateFormat;
    }

    public File getSourceTemplate() {
        return sourceTemplate;
    }

    public void setSourceTemplate(File sourceTemplate) {
        this.sourceTemplate = sourceTemplate;
    }

    public File getTargetFile() {
        return targetFile;
    }

    public void setTargetFile(File targetFile) {
        this.targetFile = targetFile;
    }

    public List<?> getData() {
        return data;
    }

    public void setData(List<?> data) {
        this.data = data;
    }

    public String[] getAutoSizeColumn() {
        return autoSizeColumn;
    }

    public void setAutoSizeColumn(String[] autoSizeColumn) {
        this.autoSizeColumn = autoSizeColumn;
    }

    public String[] getSumColumn() {
        return sumColumn;
    }

    public void setSumColumn(String[] sumColumn) {
        this.sumColumn = sumColumn;
    }

    public Integer getFlushSize() {
        return flushSize;
    }

    public void setFlushSize(Integer flushSize) {
        this.flushSize = flushSize;
    }

    public Boolean getAutoSize() {
        return autoSize;
    }

    public void setAutoSize(Boolean autoSize) {
        this.autoSize = autoSize;
    }

    public String getRemark1() {
        return remark1;
    }

    public void setRemark1(String remark1) {
        this.remark1 = remark1;
    }

}