经过改良后可以导出超过70000条数据的导出公共excel类

最新推荐文章于 2024-08-26 18:12:37 发布

weixin_30544657

最新推荐文章于 2024-08-26 18:12:37 发布

阅读量251

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wanghongjie/p/6116245.html

本文介绍了一种使用Java批量将List集合数据导出为多个Excel文件的方法，通过将大数据集拆分为若干个小批次来避免单个Excel文件超过65536行的限制。该方法适用于需要大量数据导出的应用场景。

public static <T> void export(OutputStream os, List<T> obj, String[] head,String[] fidldName)
throws Exception {
// 创建工作薄
WritableWorkbook workbook = Workbook.createWorkbook(os);
double num =Math.ceil(obj.size()/65000d);
if (num>1) {
for (int i =0; i < num; i++) {
List<T> objj=new ArrayList<T>();
int max=0;
int k=0;
if (obj.size()<=65536) max=obj.size();
if (obj.size()>65536) max=65536*i+65536;
if (num-1==i) max=obj.size();
for (int j = 65536*i; j < max; j++) {
objj.add(k, obj.get(j));
k++;
}
exportS(os,objj,head,fidldName,(int)num,workbook);
}
}else{
exportS(os,obj,head,fidldName,(int)num,workbook);
}
workbook.write();
workbook.close();
os.close();
}
public static <T> void exportS(OutputStream os, List<T> obj, String[] head,String[] fidldName,int num,WritableWorkbook workbook) throws Exception {

// 创建新的一页
WritableSheet sheet = workbook.createSheet("Sheet"+num,num);
// 创建要显示的具体内容
// String[] head = HeaderExcel.List;
for (int i = 0; i < head.length; i++) {
Label formate = new Label(i, 0, head[i] + "", titleFormat);
sheet.addCell(formate);
}
int i = 0;
Field field = null;
for (T t : obj) {
Object [] objw=new Object[50];
int k = 0;
//System.err.println(fidldName.length);

for (int j = 0; j < fidldName.length; j++) {
field = t.getClass().getDeclaredField(fidldName[j]);
field.setAccessible(true);
if(field.get(t) != null)
objw[k]=field.get(t);
else
objw[k]="-";
k++;
}

for (int j = 0; j < head.length; j++) {
Label data = new Label(j, 1 + i, "" + objw[j]);
sheet.addCell(data);
}
i++;
}

}