|
這里主要是要針對(duì)數(shù)據(jù)量過(guò)大,通過(guò)生成多個(gè)excel文件并打成一個(gè)zip壓縮包提供下載.
壓縮excel的類 ZipUtil：
- import java.io.*;
- import java.util.*;
- import java.util.zip.ZipOutputStream;
- import java.util.zip.ZipEntry;
- import java.util.zip.ZipFile;
- import org.apache.commons.logging.Log;
- import org.apache.commons.logging.LogFactory;
-
-
- public class ZipUtil {
-
- private static final Log log = LogFactory.getLog(ZipUtil.class);
-
-
- /**
- * 壓縮文件
- *
- * @param srcfile File[] 需要壓縮的文件列表
- * @param zipfile File 壓縮后的文件
- */
- public static void zipFiles(List<File> srcfile, File zipfile) {
- byte[] buf = new byte[1024];
- try {
- // Create the ZIP file
- ZipOutputStream out = new ZipOutputStream(new FileOutputStream(zipfile));
- // Compress the files
- for (int i = 0; i < srcfile.size(); i++) {
- File file = srcfile.get(i);
- FileInputStream in = new FileInputStream(file);
- // Add ZIP entry to output stream.
- out.putNextEntry(new ZipEntry(file.getName()));
- // Transfer bytes from the file to the ZIP file
- int len;
- 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) {
- log.error("ZipUtil zipFiles exception:"+e);
- }
- }
-
- /**
- * 解壓縮
- *
- * @param zipfile File 需要解壓縮的文件
- * @param descDir String 解壓后的目標(biāo)目錄
- */
- public static void unZipFiles(File zipfile, String descDir) {
- try {
- // Open the ZIP file
- ZipFile zf = new ZipFile(zipfile);
- for (Enumeration entries = zf.entries(); entries.hasMoreElements();) {
- // Get the entry name
- ZipEntry entry = ((ZipEntry) entries.nextElement());
- String zipEntryName = entry.getName();
- InputStream in = zf.getInputStream(entry);
- // System.out.println(zipEntryName);
- OutputStream out = new FileOutputStream(descDir + zipEntryName);
- byte[] buf1 = new byte[1024];
- int len;
- while ((len = in.read(buf1)) > 0) {
- out.write(buf1, 0, len);
- }
- // Close the file and stream
- in.close();
- out.close();
- }
- } catch (IOException e) {
- log.error("ZipUtil unZipFiles exception:"+e);
- }
- }
-
- /**
- * Main
- *
- * @param args
- */
- public static void main(String[] args) {
- List<File> srcfile=new ArrayList<File>();
- srcfile.add(new File("e:\\1.xls"));
- srcfile.add(new File("e:\\2.xls"));
- srcfile.add(new File("e:\\3.xls"));
- srcfile.add(new File("e:\\4.xls"));
- srcfile.add(new File("e:\\5.xls"));
-
- File zipfile = new File("e:\\edm.zip");
- ZipUtil.zipFiles(srcfile, zipfile);
- }
- }
生成多個(gè)excel 類：
- /**
- * forward:導(dǎo)出Excel
- * @throws Exception
- */
- private ModelAndView forwardExport2Excel(HttpServletRequest request, HttpServletResponse response)
- throws Exception{
- try {
-
- Integer page=0;//頁(yè)數(shù)
- Integer pagesize=Integer.valueOf(PropertiesUtil.getPropertyValue("PAGESIZE"));//每頁(yè)顯示數(shù)
- Integer total=0;//總數(shù)
- int pageindex=1;//當(dāng)前頁(yè)數(shù)
- Integer rowfrom = 1;
- Integer rowto = 10;
- total =service.getTotal();
- if(total<pagesize){
- page=1;
- System.out.println("from:"+rowfrom+"---"+total);
- List<Object> list = new ArrayList<Object>();
- list = service.getAllList(rowfrom,total);
- JXLUtil.writeEmailInfo2Excel(response, "郵箱信息總覽", "titles", list,pageindex);
- }else{
- Integer mode=total%pagesize;
- if(mode!=0){
- page=total/pagesize+1;
- }else{
- page=total/pagesize;
- }
- if(total!=0 && page!=0){
- while(pageindex<=page ){
- if(total<0){
- break;
- }
- if( total>pageindex*pagesize ){
- System.out.println("from:"+(rowfrom)+"----"+pageindex*pagesize);
- List<Object> list = new ArrayList<Object>();
- list = service.getAllList(rowfrom,pagesize);
- JXLUtil.writeEmailInfo2Excel(response, "郵箱信息總覽", "titles", list,pageindex);
- rowfrom=pageindex*pagesize;
- pageindex++;
- }else{
- System.out.println("from:"+rowfrom+"--"+total);
- List<Object> list = new ArrayList<Object>();
- list = service.getAllList(rowfrom,total);
- JXLUtil.writeEmailInfo2Excel(response, "郵箱信息總覽", "titles", list,pageindex);
- break;
- }
- }
- }
- }
- List<File> srcfile=new ArrayList<File>();
- for(int p=1;p<=page;p++){
- srcfile.add(new File(PropertiesUtil.getPropertyValue("URL")+"zipname"+p+".xls"));
- }
- File zipfile = new File(PropertiesUtil.getPropertyValue("OUTPATH")+"zipname.zip");
- ZipUtil.zipFiles(srcfile, zipfile);
- String path = request.getContextPath();
- String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
- writeObject("成功導(dǎo)出excel 地址：<html><a href="+basePath+"zipname.zip>點(diǎn)擊下載</a></html>", response);
-
- } catch (Exception e) {
- log.error("error:"+e);
- }
- return null;
- }
jxl生成excel參考我之前的一篇即可
|
