com.github.zzlhy.entity.TableParam Maven / Gradle / Ivy

Go to download
package com.github.zzlhy.entity;

import java.util.List;

/**
 * Excel表格参数配置
 * Created by Administrator on 2017-11-29.
 */
public class TableParam {

    //Sheet名称
    private String sheetName="Sheet";

    //每个sheet允许的数据行数,超过此行数会创建新的sheet (xlsx最大值为1048576)
    private int sheetDataTotal = 500000;

    //导出时开始写入的起始行,默认从0开始
    private Integer startRow=0;

    //导入时,起始读取行
    private Integer readRow=1;

    //行高度
    private float height = 15;

    //是否创建标题行
    private Boolean createHeadRow=true;

    //标题行设置
    private HeadRowStyle headRowStyle=new HeadRowStyle();

    //导出Excel类型xls/xlsx   默认为xlsx
    private ExcelType excelType=ExcelType.XLSX;

    //列属性数组
    private List cols;

    public TableParam() {
    }

    public TableParam(List cols) {
        this.cols = cols;
    }

    public TableParam(int sheetDataTotal, List cols) {
        this.sheetDataTotal = sheetDataTotal;
        this.cols = cols;
    }

    public TableParam(String sheetName, Integer startRow, float height) {
        this.sheetName = sheetName;
        this.startRow = startRow;
        this.height = height;
    }

    public TableParam(ExcelType excelType) {
        this.excelType = excelType;
    }

    public String getSheetName() {
        return sheetName;
    }

    public int getSheetDataTotal() {
        return sheetDataTotal;
    }

    public void setSheetDataTotal(int sheetDataTotal) {
        this.sheetDataTotal = sheetDataTotal;
    }

    public void setSheetName(String sheetName) {
        this.sheetName = sheetName;
    }

    public Integer getStartRow() {
        return startRow;
    }

    public void setStartRow(Integer startRow) {
        this.startRow = startRow;
    }

    public List getCols() {
        return cols;
    }

    public void setCols(List cols) {
        this.cols = cols;
    }

    public float getHeight() {
        return height;
    }

    public void setHeight(float height) {
        this.height = height;
    }

    public Boolean getCreateHeadRow() {
        return createHeadRow;
    }

    public void setCreateHeadRow(Boolean createHeadRow) {
        this.createHeadRow = createHeadRow;
    }

    public HeadRowStyle getHeadRowStyle() {
        return headRowStyle;
    }

    public void setHeadRowStyle(HeadRowStyle headRowStyle) {
        this.headRowStyle = headRowStyle;
    }

    public Integer getReadRow() {
        return readRow;
    }

    public void setReadRow(Integer readRow) {
        this.readRow = readRow;
    }

    public ExcelType getExcelType() {
        return excelType;
    }

    public void setExcelType(ExcelType excelType) {
        this.excelType = excelType;
    }
}