ExcelConfig.java
2.97 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
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;
}
}