导出Excel(终极版)

/**
	 * 导出excel 案例
	 */
	public void exportExcel(){
		long beginTime = System.currentTimeMillis();
		HttpServletResponse response= ServletActionContext.getResponse();
		OutputStream os=null;
		if(activityForm==null){
			activityForm=new ActivityForm();
		}
		try {
			activityForm.setStartSize((getCurrentpage()-1)*getPagesize());
			activityForm.setPageSize(getPagesize());
			activityForm.setUserInfoId(getUserInfoSession().getId());
			PageList<ActivityForm> page=iActivityService.getPage(activityForm);
			activityForm.setPageSize(page.getTotalcount());
			List<ActivityForm> activitys=iActivityService.getPage(activityForm).getResult();
			
			Workbook createbook = createActivityBook(activitys);
			// 创建下载文件名
			String uploadFileName = System.currentTimeMillis() + ".xls";
			os = response.getOutputStream();// 取得输出流
			response.reset();// 清空输出流
			response.setHeader("Content-disposition", "attachment; filename="+ uploadFileName);// 设定输出文件头
			response.setContentType("application/x-download");
			createbook.write(os);
			os.close();
		} catch (Exception e) {
			error("请求exportActivity方法异常",e);
		}finally{
			printTime(beginTime, getClass(), "exportActivity");
		}
	}

　　

public static HSSFWorkbook createActivityBook(List<ActivityForm> list){
		// 创建Excel文档
		HSSFWorkbook hwb = new HSSFWorkbook();
		ActivityForm activityForm=null;
		// sheet 对应一个工作页
		HSSFSheet sheet = hwb.createSheet("导出活动列表信息");
		int CountColumnNum = 5;  //指定列头个数
		HSSFRow firstrow = sheet.createRow(0); // 下标为0的行开始
		HSSFCell[] firstcell = new HSSFCell[CountColumnNum];
		String[] names = new String[CountColumnNum];
		names[0] = "活动名称";
		names[1] = "活动类型";
		names[2] = "活动链接";
		names[3] = "备注";
		names[4] = "创建时间";
		for (int j = 0; j < CountColumnNum; j++) {
			firstcell[j] = firstrow.createCell(j);
			firstcell[j].setCellValue(new HSSFRichTextString(names[j]));
		}
		for (int i = 0; i < list.size(); i++) {
			// 创建一行
			HSSFRow row = sheet.createRow(i + 1);
			// 得到要插入的每一条记录
			activityForm = list.get(i);
			for (int colu = 0; colu < CountColumnNum; colu++) {
				// 在一行内循环
				HSSFCell name = row.createCell(0);
				HSSFCell type = row.createCell(1);
				HSSFCell url = row.createCell(2);
				HSSFCell remark = row.createCell(3);
				HSSFCell createDate = row.createCell(4);
				
				name.setCellValue(activityForm.getName());
				type.setCellValue(activityForm.getType());
				url.setCellValue(activityForm.getUrl());
				remark.setCellValue(activityForm.getRemark());
				createDate.setCellValue(activityForm.getCreateDate());
			}
		}
		return hwb;
	}

　　

import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;