java导出多个excel压缩zip下载

package com.xx.emidas.activity.biz.utils;import java.io.BufferedOutputStream;import java.io.ByteArrayInputStream;import java.io.ByteArrayOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.lang.reflect.Field;import java.lang.reflect.InvocationTargetException;import java.lang.reflect.Method;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.zip.ZipEntry;import java.util.zip.ZipOutputStream;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.ws.rs.core.Application;import jxl.Workbook;import jxl.format.Alignment;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;import jxl.write.WriteException;import org.apache.commons.collections.CollectionUtils;import org.apache.struts2.ServletActionContext;import com.dianping.combiz.util.DateUtils;/** * 批量导出excel生成zip * @author hongwang.zhang 16-01-29 * */public class ExcelGenerateZIP {static HttpServletRequest request=ServletActionContext.getRequest();static int recordNum = 60000;public static void main(String[] args) {int s=getSheetCount(52300);System.out.println(1);}/**     * 确定分页的个数     *     * @param rCount 总得记录条数     * @return     */    private static int getSheetCount(int rCount) {        if (recordNum <= 0)            return 1;        if (rCount <= 0)            return 1;        int n = rCount % (recordNum); // 余数        if (n == 0) {            return rCount / recordNum;        } else {            return (int) (rCount / (recordNum - 1)) + 1;        }    }//忽略警告@SuppressWarnings("unchecked") public static String  batchExport(List list) throws IOException,    WriteException{SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHSS");          String path = sdf.format(new Date());         //获取服务器web路径        String serverPath=request.getRealPath("/")+path;        System.out.println(serverPath); //在服务器端创建文件夹        File file = new File(serverPath);        if(!file.exists()){        file.mkdir(); //创建文件夹          }if(CollectionUtils.isEmpty(list)){return null;}       Class clazz = list.get(0).getClass();       // 文件流       ByteArrayOutputStream ostream = new ByteArrayOutputStream();       WritableWorkbook book = null;       //获取导出多少个excel        int excelCount=getSheetCount(list.size());        //导出每个excel        int fromIndex=0;        int toIndex=list.size()<60000?list.size():60000;        for(int excel=0;excel<excelCount;excel++){        List listExcel=null;        if(toIndex>list.size()){        listExcel=list.subList(fromIndex, list.size());        }else{         listExcel=list.subList(fromIndex,toIndex);        }try {book = Workbook.createWorkbook(new File(serverPath+"/" + new SimpleDateFormat("yyyyMMddHHmmsss").format(new Date() )+"_"+(excel+1)+".xls"));} catch (IOException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}       WritableSheet ws = null;       Label lable = null;       int rowIndex = 0;       int rCount = listExcel.size() > 0 ? listExcel.size() : 0; // 行数       int sheetCount = getSheetCount(rCount);// 获取分页工作表的个数       for (int i = 0; i < sheetCount; i++) {// 初始化工作表的个数           book.createSheet("Sheet-" + i, i); // 添加一个工作表       }       for (int index = 0; index < sheetCount; index++) {           ws = book.getSheet(index);// 获取工作簿的第一个工作表           // 列标           WritableFont wfColumn = new WritableFont(WritableFont.TIMES, 10,                   WritableFont.BOLD, false);           WritableCellFormat wcfColumn = new WritableCellFormat(wfColumn);           wcfColumn.setAlignment(Alignment.CENTRE);           wcfColumn.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);           int j = 0;           // 标题           Field[] fields = clazz.getDeclaredFields();           for (int i = 0; i < fields.length; i++) {               if (!fields[i].getName().equalsIgnoreCase("serialVersionUID") && !fields[i].getName().equalsIgnoreCase("$jacocoData")) {                   lable = new Label(j++, 0, fields[i].getName(), wcfColumn);                   ws.addCell(lable);               }           }           Method[] methods = clazz.getMethods();           List<Method> getMethods = new ArrayList<Method>();           for (j = 0; j < fields.length; j++) {               for (int i = 0; i < methods.length; i++) {                   if (methods[i].getName().equalsIgnoreCase(                           "get" + fields[j].getName())) {                       getMethods.add(methods[i]);                   }               }           }           // 内容           WritableCellFormat wcfCell = new WritableCellFormat();           wcfCell.setAlignment(Alignment.CENTRE);           wcfCell.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);           int i = 0;           for (int k = rowIndex; k < listExcel.size(); k++) {               Object obj = null;               obj = list.get(k);               int r = 0;               i++;               if (recordNum == i) {                   rowIndex += recordNum - 1;                   break;               } else {                   for (Method method : getMethods) {                       try {                           Object result = method.invoke(obj);                           if (result == null) {                               result = "";                           }                           if (result instanceof Date) {                               result = DateUtils.format((Date) result,                                       DateUtils.getSecondFormatter());                           }                           lable = new Label(r++, i, result == null ? ""                                   : result.toString(), wcfCell);                           ws.addCell(lable);                       } catch (IllegalArgumentException e) {                           e.printStackTrace();                       } catch (IllegalAccessException e) {                           e.printStackTrace();                       } catch (InvocationTargetException e) {                           e.printStackTrace();                       }                   }               }           }       }       book.write();       book.close();       fromIndex+=60000;       toIndex+=60000;        }        return serverPath;      /* InputStream istream = new ByteArrayInputStream(ostream.toByteArray());       return istream;*/       //return  null;}/** * 生成.zip文件; * @param path * @throws IOException  */public static InputStream craeteZipPath(String path) throws IOException{ZipOutputStream zipOutputStream = null;String lj=path+new SimpleDateFormat("yyyyMMddHHmmss").format(new Date())+".zip";File file = new File(lj);zipOutputStream = new ZipOutputStream(new BufferedOutputStream(new FileOutputStream(file)));File[] files = new File(path).listFiles();FileInputStream fileInputStream = null;byte[] buf = new byte[1024];int len = 0;if(files!=null && files.length > 0){for(File excelFile:files){String fileName = excelFile.getName();fileInputStream = new FileInputStream(excelFile);//放入压缩zip包中;zipOutputStream.putNextEntry(new ZipEntry(path + "/"+fileName));//读取文件;while((len=fileInputStream.read(buf)) >0){zipOutputStream.write(buf, 0, len);}//关闭;zipOutputStream.closeEntry();if(fileInputStream != null){fileInputStream.close();}}}if(zipOutputStream !=null){zipOutputStream.close();} File f = new File(lj); InputStream istream = new FileInputStream(f);return istream;}}

这个是利用jxl写的一个工具类 拿过来就可以直接用  jar我就不提供下载了网上很多的。里面部分功能不是很完善但是可以用的

try {     String path=ExcelGenerateZIP.batchExport(listWinningRecordDTOList);     InputStream data= ExcelGenerateZIP.craeteZipPath(path);/*InputStream data = JxlHelper.getExcel(listWinningRecordDTOList);*/actionContext.getContext().put("data", data);} catch (Exception e) {e.printStackTrace();}

protected ActionContext actionContext;  里面的list     List<WinningRecordExportDTO> listWinningRecordDTOList 是这种格式的

 <action name="selectPrizePackageInformationDown" class="com.dianping.emidas.activity.prizePool.SelectPrizePackageInformationAction" method="download"><result name="success" type="stream"><param name="contentType">application/x-zip-compressed</param><param name="inputName">data</param><param name="contentDisposition">filename=data.zip</param><param name="bufferSize">409600000</param></result></action>

这个是struts2的配置文件了