poi百万级数据导出excel

通过传入实体类数组和指定导出列来即可，导出excel，读者可直接复制到项目直接使用，下面只是个简单的示例提供参考

一、导出excel工具类代码

   
   
	/**
	 * 导出实体类
	 * @param head 表头
	 * @param exportColumn 导出字段
	 * @param exportList 实体数组
	 * @param clazz 实体类
	 * @return
	 * @throws Exception
	 */
	public  SXSSFWorkbook export(String[] head,String[] exportColumn,List exportList,Class clazz) throws Exception{
		 XSSFWorkbook  wb = new XSSFWorkbook ();
	     SXSSFWorkbook swb=new SXSSFWorkbook(wb,1000);
	        //swb.createSheet()
	        //创建第一个sheet（页），命名为 new sheet
	        SXSSFSheet sheet = null;
	        sheet = (SXSSFSheet) swb.createSheet("myData");
		//创建head
		SXSSFRow heqadrow = sheet.createRow(0);
		int headlen = head.length;
		for(int i=0;i<headlen;i++) {
			heqadrow.createCell(i).setCellValue(head[i]);
		}
		//获取导出列
		List<String> columnNameList = new ArrayList<String>();
		if(exportColumn!=null&&exportColumn.length>0) {
			int columnNameLen = exportColumn.length;
			for(int i=0;i<columnNameLen;i++){
				columnNameList.add(exportColumn[i]);
			}
		} else {//通过反射获取所有列
			//暂未实现
			System.err.println("请指明导出列");
		}
		//导出列
		int exportListLen = exportList.size();
		List<Method> methodList = new ArrayList<Method>();
		int columnNameListLen =  columnNameList.size();
		for(int i=0;i<columnNameListLen;i++){
			String methodName= "get".concat(captureName(columnNameList.get(i).toLowerCase()));
			Method method = clazz.getMethod(methodName);
			methodList.add(method);
		}
		for(int i=1;i<=exportListLen;i++){
			Object entity = exportList.get(i-1);
			SXSSFRow row = sheet.createRow(i);
			for(int j=0;j<columnNameListLen;j++) {
				Object value = methodList.get(j).invoke(entity);
				if(value!=null) {
					row.createCell(j).setCellValue(value.toString());
				}
			}
		}
		//写入文件
		/*FileOutputStream fos = new FileOutputStream("e:\\txt.xls");
		swb.write(fos);
		fos.flush();*/
		return swb;
	}

二、导出excel的controller下载部分

   
   
SXSSFWorkbook wb = eu.export(head, exportColumn, easyJson.getRows(), TReportyszxqk.class);
OutputStream output=response.getOutputStream(); //response为springMVC传入的httpservletResponse 
response.reset();  
response.setHeader("Content-disposition", "attachment; filename=details.xls");  
response.setContentType("application/msexcel");          
wb.write(output);  
output.close(); 

三、前端下载部分

1.html

   
   
<form action="exportYszx" style="display:none" id="downForm" method="post">		
</form>

    
    
<button  id="btn_export"> 导出</button>

2.js

   
   
$("#btn_export").click(function(){
			$("#downForm").empty();
			for(var key in searchData){
				var input = "<input name='"+key+"'value='"+searchData[key]+"'>";
				$("#downForm").append(input)
			}
			$("#downForm").submit();
		})