java下载execl

最新推荐文章于 2024-04-28 08:30:00 发布

nich_olas

最新推荐文章于 2024-04-28 08:30:00 发布

阅读量148

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/nich_olas/article/details/90265969

版权

java 专栏收录该内容

11 篇文章 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;
}