HSSF导出详细笔记

最新推荐文章于 2023-12-27 00:28:12 发布

礼拜五的五

最新推荐文章于 2023-12-27 00:28:12 发布

阅读量266

点赞数

分类专栏： Java 文章标签： Java

本文链接：https://blog.csdn.net/CSDN_97Lee/article/details/103123012

版权

Java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏


public void export(HttpServletRequest request, HttpServletResponse response, Map<String, String> queryMap) {
		/* 调用查询方法，获取要查询的数据 */
		ArrayList<Map<String, Object>> resultList = query(queryMap);
		/* 创建工作簿 */
		HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
		/* 创建Sheet页 */
		HSSFSheet hssfSheet = hssfWorkbook.createSheet();
		/* 创建标题行并赋标题 */
		HSSFRow titleRow = hssfSheet.createRow(0);
		HSSFCell titleCell = titleRow.createCell(0);
		titleCell.setCellValue("标题");
		/* 合并单元格 */
		hssfSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 5));
		/* 创建列头 */
		HSSFRow CellTitle = hssfSheet.createRow(1);
		/* 给列头赋值 */
		CellTitle.createCell(0).setCellValue("编号");
		CellTitle.createCell(1).setCellValue("姓名");
		CellTitle.createCell(2).setCellValue("性别");
		CellTitle.createCell(3).setCellValue("年龄");
		CellTitle.createCell(4).setCellValue("部门");
		CellTitle.createCell(5).setCellValue("职务");
		/* 遍历结果集，向sheet页中插入数据 */
		for (int i = 0; i < resultList.size(); i++) {
			Map<String, Object> dataMap = resultList.get(i);
			HSSFRow dataRow = hssfSheet.createRow(i + 2);// 因为有标题跟列头，所以要加2
			/* 三目运算用来处理空值 */
			dataRow.createCell(0).setCellValue(dataMap.get("ID") == null ? "" : dataMap.get("ID").toString());
			dataRow.createCell(1).setCellValue(dataMap.get("NAME") == null ? "" : dataMap.get("ID").toString());
			dataRow.createCell(2).setCellValue(dataMap.get("GENDER") == null ? "" : dataMap.get("ID").toString());
			dataRow.createCell(3).setCellValue(dataMap.get("AGE") == null ? "" : dataMap.get("ID").toString());
			dataRow.createCell(4).setCellValue(dataMap.get("DEPARTMENT") == null ? "" : dataMap.get("ID").toString());
			dataRow.createCell(5).setCellValue(dataMap.get("POSITION") == null ? "" : dataMap.get("ID").toString());
		}
		/* 输出文件 */
		try {
			/* 给文件命名 */
			String fileName = "人员信息.xls";
			OutputStream outputStream = response.getOutputStream();
			response.reset();
			response.setContentType("multipart/form-data");
			String exportFileName = URLEncoder.encode(fileName, "UTF-8");
			if (fileName.length() > 150) {
				String clientCharset = request.getCharacterEncoding();
				exportFileName = new String(fileName.getBytes(clientCharset), "ISO8859-1");
			}
			response.setHeader("Content-Disposition", "attachment; fileName=" + exportFileName);
			response.setCharacterEncoding("UTF-8");
			hssfWorkbook.write(outputStream);
			outputStream.flush();
			outputStream.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}