poi导出excel

最新推荐文章于 2019-03-09 16:52:32 发布

aisinilehehe

最新推荐文章于 2019-03-09 16:52:32 发布

阅读量110

点赞数

分类专栏： springmvc 文章标签： poi

本文链接：https://blog.csdn.net/liu911025/article/details/79556485

版权

springmvc 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

	@RequestMapping("/export/score")
	public void exportClassScore(HttpServletRequest request, HttpServletResponse response) throws IOException {
		ServletOutputStream out = response.getOutputStream();
		String fileName = "导入模版.xls";
		response.setHeader("Content-Disposition", "attachment;filename="+ new String(fileName.getBytes(),"ISO-8859-1"));
		examPaperService.exportClassScore(out);
	}

@Override
	public void exportClassScore(ServletOutputStream out) {
HSSFWorkbook book = new HSSFWorkbook();
		
		String sheetName = "导入模版";
		
		HSSFSheet sheet = book.createSheet(sheetName);
		
		HSSFRow row_1 = sheet.createRow(0);
		row_1.createCell(0).setCellValue("");
		row_1.createCell(1).setCellValue("最高气温");
		row_1.createCell(2).setCellValue("最低气温");
		row_1.createCell(3).setCellValue("平均气温");
		
		HSSFRow row_2 = sheet.createRow(1);
		row_2.createCell(0).setCellValue("周一");
		row_2.createCell(1).setCellValue("12.0");
		row_2.createCell(2).setCellValue("23.0");
		row_2.createCell(3).setCellValue("10.0");
		
		HSSFRow row_3 = sheet.createRow(2);
		row_3.createCell(0).setCellValue("周二");
		row_3.createCell(1).setCellValue("11.0");
		row_3.createCell(2).setCellValue("24.0");
		row_3.createCell(3).setCellValue("9.0");
		
		HSSFRow row_4 = sheet.createRow(3);
		row_4.createCell(0).setCellValue("周三");
		row_4.createCell(1).setCellValue("12.5");
		row_4.createCell(2).setCellValue("22.0");
		row_4.createCell(3).setCellValue("11.0");
		
		HSSFRow row_5 = sheet.createRow(4);
		row_5.createCell(0).setCellValue("周四");
		row_5.createCell(1).setCellValue("13.5");
		row_5.createCell(2).setCellValue("20.0");
		row_5.createCell(3).setCellValue("12.0");
		
		HSSFRow row_6 = sheet.createRow(5);
		row_6.createCell(0).setCellValue("周五");
		row_6.createCell(1).setCellValue("16.0");
		row_6.createCell(2).setCellValue("24.0");
		row_6.createCell(3).setCellValue("12.0");
		
		try {
			book.write(out);
			book.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}