java下载execl

￡神魔★判官ぃ 2022-01-31 11:47 184阅读 0赞

## pom.xml ##

--------------------

<dependency>
    		    <groupId>org.apache.poi</groupId>
    		    <artifactId>poi-ooxml</artifactId>
    		    <version>3.9</version>
    		</dependency>

### Controller ###

--------------------

@Autowired
    	private HttpServletResponse response;
    	
    	@ResponseBody
    	@RequestMapping("download_execl")
    	public void download_execl(LandingPageDto landingPageDto) throws IOException{ 
    		List<LoanDataDto> list = projectService.download_execl_select(landingPageDto.download_execl_select());
    		// 第一步，创建一个HSSFWorkbook，对应一个Excel文件
    		HSSFWorkbook wb = new HSSFWorkbook();
    		HSSFSheet sheet = wb.createSheet("sheet1");
    		HSSFRow row = sheet.createRow(0);
    		// 第四步，创建单元格，并设置值表头 设置表头居中
            HSSFCellStyle style = wb.createCellStyle();
            style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
            //声明列对象
            HSSFCell cell = null;
            //创建标题
            cell = row.createCell(0);
            cell.setCellValue("电话");
            int line = 1;
            for(int i=0;i<list.size();i++){ 
         	   row = sheet.createRow(line);
         	   line++;
         	   LoanDataDto loanDataDto = list.get(i);
                if(BaseUtils.checkStringempty(loanDataDto.getPhone())){ 
             	   	cell = row.createCell(0);
             	   	cell.setCellValue(loanDataDto.getPhone());
     			}
            }
            //输出Excel文件
            OutputStream output=response.getOutputStream();
            response.reset();
            String filename = "domo".xls";
            response.setHeader("Content-disposition", "attachment; filename="+ new String(filename.getBytes("UTF8"), "ISO8859-1"));//文件名这里可以改
            response.setContentType("application/vnd.ms-excel");
            wb.write(output);
            output.close();
    	}

## html ##

--------------------

<button type="button" data-th-disabled = "${total_forward_num eq 0}" class="btn btn-primary" onclick="download_execl()">下载号码</button>
    function download_execl(){ 
    		var param = $("#fileForm").serialize();
    		window.location.href = "download_execl?"+param;
    }