java动态生成excel_java动态生成excel打包下载

@SuppressWarnings("unchecked")public String batchExport() throwsDBException{

@SuppressWarnings("unused")

List chkList= this.checkValueToList();//获取复选框的值

List srcfile=newArrayList();

SimpleDateFormat sdf= new SimpleDateFormat("yyyyMMddHHSS");

String path= sdf.format(newDate());

String serverPath= request.getSession().getServletContext().getRealPath("/");//在服务器端创建文件夹

File file = new File(serverPath+path);if(!file.exists()){

file.mkdir();

}for (int i = 0; i < chkList.size(); i++){

String t[]= chkList.get(i).split("\\|");

LhjcOrgSelfQuery lhjcunioncheckquery= newLhjcOrgSelfQuery();

lhjcunioncheckquery.setChnoticeId(t[0]);

lhjcunioncheckquery.setOrgId(t[1]);

lhjcunioncheckquery.setSelfChTempId(t[2]);

List> reportViews=commonService.getObjectPages("ExportLhjcunioncheckresultReportView", lhjcunioncheckquery);

String orgName= (String)commonService.get2Object("getUnioncheckOrgName", t[1]);//生成excel的名字

String templateName = nyear+"深圳市党政机关信息安全检查结果-"+(orgName==null?"未知单位":orgName);

String[] headArray= new String[]{"编码","检查项名称"," 检查内容 ","考核类型"," 检查结果 "," 备注 ","权重","得分"};

String[] fieldArray= new String[]{"CHECKITEMCODE","CHITEMNAME","CHCONTENT","REPORTTYPE","QUESTDESC","CHITEMDESC","REPORTWEIGHT","UNIONSCORE"};

ExportUtils exportUtils= newExportUtils();

exportUtils.setTitle(templateName);

exportUtils.setHead(templateName);

exportUtils.setHeadArray(headArray);

exportUtils.setFieldArray(fieldArray);try{

HttpServletResponse response=ServletActionContext.getResponse();

SimpleDateFormat sfm= new SimpleDateFormat("yyyy-MM-dd");

String filename= templateName + "_" + sfm.format(newDate());

String encodedfileName= new String(filename.getBytes(), "GBK");//将生成的多个excel放到服务器的指定的文件夹中

FileOutputStream out = new FileOutputStream(serverPath+path+"\"+encodedfileName+".xls");

if(fileType.indexOf(",") != -1){

fileType= StringUtils.substringBefore(fileType, ",");

}

response.setHeader("Content-Disposition", " filename="" + encodedfileName + "." + fileType + """);//导出excel

if ("xls".equals(fileType) || "xlsx".equals(fileType)) {

exportUtils.exportExcel(reportViews,fileType,out);

}else if("doc".equals(fileType) || "docx".equals(fileType)){

exportUtils.exportWord(reportViews, fileType, out);

}else if("pdf".equals(fileType)){

exportUtils.exportPdf(reportViews, out);

}

srcfile.add(new File(serverPath+path+"\"+encodedfileName+".xls"));

}catch(Exception e) {

e.printStackTrace();

}

}//将服务器上存放Excel的文件夹打成zip包

File zipfile = new File(serverPath+path+".zip");this.zipFiles(srcfile, zipfile);//弹出下载框供用户下载

this.downFile(ServletActionContext.getResponse(),serverPath, path+".zip");return null;

}public voidzipFiles(List srcfile, File zipfile) {byte[] buf = new byte[1024];try{//Create the ZIP file

ZipOutputStream out = new ZipOutputStream(newFileOutputStream(zipfile));//Compress the files

for (int i = 0; i < srcfile.size(); i++) {

File file=srcfile.get(i);

FileInputStream in= newFileInputStream(file);//Add ZIP entry to output stream.

out.putNextEntry(newZipEntry(file.getName()));//Transfer bytes from the file to the ZIP file

intlen;while ((len = in.read(buf)) > 0) {

out.write(buf,0, len);

}//Complete the entry

out.closeEntry();

in.close();

}//Complete the ZIP file

out.close();

}catch(IOException e) {

e.printStackTrace();

}

}public voiddownFile(HttpServletResponse response,String serverPath, String str) {try{

String path= serverPath +str;

File file= newFile(path);if(file.exists()) {

InputStream ins= newFileInputStream(path);

BufferedInputStream bins= new BufferedInputStream(ins);//放到缓冲流里面

OutputStream outs = response.getOutputStream();//获取文件输出IO流

BufferedOutputStream bouts = newBufferedOutputStream(outs);

response.setContentType("application/x-download");//设置response内容的类型

response.setHeader("Content-disposition","attachment;filename="

+ URLEncoder.encode(str, "GBK"));//设置头部信息

int bytesRead = 0;byte[] buffer = new byte[8192];//开始向网络传输文件流

while ((bytesRead = bins.read(buffer, 0, 8192)) != -1) {

bouts.write(buffer,0, bytesRead);

}

bouts.flush();//这里一定要调用flush()方法

ins.close();

bins.close();

outs.close();

bouts.close();

}else{

response.sendRedirect("../error.jsp");

}

}catch(IOException e) {

e.printStackTrace();

}

}