java导出excel 下载文件

java操作excel所需jar包：poi-3.6-20091214.jar

    @RequestMapping("fansCount.do")
    public String getFansCount(String starTime,String endTime){
     	List
   
   
    
     list = dpService.fansCount(starTime,endTime);
     	System.out.println(list.size()+"------");
    	request.setAttribute("starTime", starTime);
    	request.setAttribute("endTime", endTime);
     	request.setAttribute("list", list);
     	
     	request.getSession().setAttribute("ysfxtj", list);//传递 
     	
    	return "/index/manage/fansCount";
    }
    
    @RequestMapping("dcExcel.do")
    public void dcExcel() throws Exception{
    	
    	
    	String path = request.getSession().getServletContext().getRealPath("/"); 
    	String xzwj = CreateSimpleExcelUtil.create((List
    
    
     
     )request.getSession().getAttribute("ysfxtj"),path);
    	
    	File file = new File(xzwj);// path是根据日志路径和文件名拼接出来的
        String filename = file.getName();// 获取日志文件名称
        InputStream fis = new BufferedInputStream(new FileInputStream(xzwj));
        byte[] buffer = new byte[fis.available()];
        fis.read(buffer);
        fis.close();
        response.reset();
        // 先去掉文件名称中的空格,然后转换编码格式为utf-8,保证不出现乱码,这个文件名称用于浏览器的下载框中自动显示的文件名
        response.addHeader("Content-Disposition", "attachment;filename=" + new String(filename.replaceAll(" ", "").getBytes("utf-8"),"iso8859-1"));
        response.addHeader("Content-Length", "" + file.length());
        OutputStream os = new BufferedOutputStream(response.getOutputStream());
        response.setContentType("application/octet-stream");
        os.write(buffer);// 输出文件
        os.flush();
        os.close();
    }
				
				
				
package com.hk.hospital.util.utils;

import java.io.File;
import java.io.FileOutputStream;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class CreateSimpleExcelUtil {
	public static String create(List
     
     
      
       list, String path)
			throws Exception {
		// 第一步，创建一个webbook，对应一个Excel文件
		HSSFWorkbook wb = new HSSFWorkbook();
		// 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet
		HSSFSheet sheet = wb.createSheet("粉丝统计表");
		// 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
		HSSFRow row = sheet.createRow((int) 0);
		// 第四步，创建单元格，并设置值表头 设置表头居中
		HSSFCellStyle style = wb.createCellStyle();
		style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式

		HSSFCell cell = row.createCell((short) 0);
		cell.setCellValue("姓名");
		cell.setCellStyle(style);
		cell = row.createCell((short) 1);
		cell.setCellValue("总粉丝数量");
		cell.setCellStyle(style);
		cell = row.createCell((short) 2);
		cell.setCellValue("添加数量");
		cell.setCellStyle(style);
		cell = row.createCell((short) 3);
		cell.setCellValue("总取消粉丝数量");
		cell.setCellStyle(style);

		// 第五步，写入实体数据 实际应用中这些数据从数据库得到，

		if(list != null && list.size() > 0){
			int i = 0;
			for (Object[] obj : list) {
				row = sheet.createRow(i + 1);
				// 第四步，创建单元格，并设置值
				row.createCell((short) 0).setCellValue((String) obj[1]);
				row.createCell((short) 1).setCellValue(obj[2].toString());
				row.createCell((short) 2).setCellValue(obj[3].toString());
				row.createCell((short) 3).setCellValue(obj[4].toString());
				i++;
			}
		}
		
		// 第六步，将文件存到指定位置
		try {

			File file = new File(path+ "\\excel");
			if (!file.exists()) {
				file.mkdir();
			}

			FileOutputStream fout = new FileOutputStream(path + "\\excel\\统计.xls");
			wb.write(fout);
			fout.close();
			return path + "\\excel\\统计.xls";
		} catch (Exception e) {
			e.printStackTrace();
			throw e;
		}
	}
}