java 实现数据列表导出 excel

/** 导出 */
public String exp() {
	TsimpSysLogQuery query = newQuery(TsimpSysLogQuery.class, DEFAULT_SORT_COLUMNS);
	Page page = tsimpSysLogManager.findPage(query);
	List list = page.getResult();

	if (list.size() > 0) {
		List list2 = new ArrayList();
		HashMap map = new LinkedHashMap();
		map.put("key_1", TsimpSysLog.ALIAS_ACCOUNT_ID);
		map.put("key_2", TsimpSysLog.ALIAS_OPERATE_IP);
		map.put("key_3", TsimpSysLog.ALIAS_GRADE);
		map.put("key_4", TsimpSysLog.ALIAS_OBJECT);
		map.put("key_5", TsimpSysLog.ALIAS_OPERATE_TIME);
		map.put("key_6", TsimpSysLog.ALIAS_TYPE);
		list2.add(map);
		for (int i = 0; i < list.size(); i++) {
			HashMap map1 = new LinkedHashMap();
			TsimpSysLog bean = (TsimpSysLog) list.get(i);
			map1.put("key_1", bean.getAccountId());
			map1.put("key_2", bean.getOperateIp());
			map1.put("key_3", bean.getGrade());
			map1.put("key_4", bean.getObject());
			map1.put("key_5", bean.getOperateTimeString());
			map1.put("key_6", bean.getType());
			list2.add(map1);
		}
		ExportExl exl = new ExportExl();
		exl.download(ServletActionContext.getRequest(), ServletActionContext.getResponse(), "SysAccount", list2, 6);
	}
	return null;
}
​

package javacommon.util;

import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class ExportExl {
	
	/** 导出
	 * exl_name 导出文件夹名字
	 *  list2 列表集合
	 *  allColumns 总列数
	 *  */
	 public void download(HttpServletRequest request, HttpServletResponse response,String exl_name ,List list2,int allColumns)
	  {
	    OutputStream os = null;
	    try {
	      os = response.getOutputStream();
	      response.reset();
	      response.setCharacterEncoding("gbk");
	      response.addHeader("Content-Disposition", "attachment;filename=" + exl_name + ".xls");
	      response.setContentType("application/vnd.ms-excel");
	      WritableWorkbook wwb = Workbook.createWorkbook(os);
	      WritableSheet ws = wwb.createSheet("sheet1", 0);
	      Label label [] = new Label[allColumns];
	      for (int k = 0; k < list2.size(); k++)
	      {
	          HashMap map = new LinkedHashMap();
	          map = (HashMap)list2.get(k);
	        	  for(int c=0;c<allColumns;c++){
	        		  String valueString=  map.get("key_"+(c+1)).toString();
	        		  label [c]  = new Label(c, k,valueString);
		              try {
						ws.addCell(label [c]);
					} catch (RowsExceededException e) {
						e.printStackTrace();
					} catch (WriteException e) {
						e.printStackTrace();
					}
	        	  }
 
	      }    
	        wwb.write();
	        wwb.close();
	      System.setOut(new PrintStream(os));
	      os.flush();
	    }
	    catch (IOException e) {
	      e.printStackTrace();
	    }
	  }
}
​