Response方式导出Excel

最新推荐文章于 2024-01-04 11:18:36 发布

weixin_33860528

最新推荐文章于 2024-01-04 11:18:36 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

文章标签： java python

原文链接：https://my.oschina.net/u/2391658/blog/834778

本文提供了一段Java代码示例，展示如何从分页数据中导出Excel文件。该方法利用了Apache POI库创建Excel工作簿，并通过HTTP响应将其发送给客户端。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

一段破代码老忘。。。

  	protected void downloadPaginExcel(HttpServletRequest request, HttpServletResponse response,Pagin<?> pagin,String fileName) throws Exception{
    	String columnObject = getParameter("columnObject");//字段对应关系
    	JSONArray myJsonArray =JSONArray.parseArray(columnObject);
    	HSSFWorkbook wb = new HSSFWorkbook(); 
    	HSSFSheet sheet = wb.createSheet("工作表1");  
    	sheet.setDefaultColumnWidth(18);  
    	sheet.setDefaultRowHeightInPoints(20);  
    	HSSFRow row = sheet.createRow((int) 0);
        for(int i=0;i<myJsonArray.size();i++){
    		JSONObject newColumn = (JSONObject) myJsonArray.get(i);
    		String colName = (String) newColumn.get("title");
    		HSSFCell cell = row.createCell(i);
        	cell.setCellValue(colName);
    	}
        
        for(int i=0;i< pagin.getResultList().size();i++){
        	Map<String,Object> newMap=ConvertObjToMap(pagin.getResultList().get(i));
        	row = sheet.createRow((int) i + 1); 
        	for(int j=0;j<myJsonArray.size();j++){
        		JSONObject newColumn = (JSONObject) myJsonArray.get(j);
        		String col = (String) newColumn.get("dataIndex");
        		String valueNew =String.valueOf(newMap.get(col)) ;
        		row.createCell(j).setCellValue(valueNew);
        	}
        }
        String newFileName=fileName+".xls";
    	response.setContentType("application/vnd.ms-excel");   
        response.setHeader("Content-disposition", "attachment;filename=" + java.net.URLEncoder.encode(newFileName, "UTF-8"));   
        OutputStream ouputStream = response.getOutputStream();   
        wb.write(ouputStream);
        ouputStream.flush();   
        ouputStream.close(); 
    }

转载于:https://my.oschina.net/u/2391658/blog/834778