使用EasyExcel进行导入导出

最新推荐文章于 2025-10-11 16:21:44 发布

原创最新推荐文章于 2025-10-11 16:21:44 发布 · 736 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#excel #poi #java

Java 专栏收录该内容

41 篇文章

订阅专栏

博客主要围绕Java中使用EasyExcel进行数据导入导出展开。介绍了EasyExcel百万级读取导入功能，还提及导出时的pom依赖以及文件名编码相关内容，为Java开发者处理大量数据的导入导出提供参考。

导入

easyExcel百万级读取导入

导出

pom依赖

	<!-- 引入Easy Excel用于excel文件的读写 -->
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>easyexcel</artifactId>
		<version>2.0.1</version>
	</dependency>

文件名编码

    public static String encodeFileName(String fileNames, HttpServletRequest request) {
        String codedFilename = null;
        try {
            String agent = request.getHeader("USER-AGENT");
            if (null != agent && -1 != agent.indexOf("MSIE") || null != agent && -1 != agent.indexOf("Trident") ||
                    null != agent && -1 != agent.indexOf("Edge")) {
                // ie浏览器及Edge浏览器
                String name = URLEncoder.encode(fileNames, "UTF-8");
                codedFilename = name;
            } else if (null != agent && -1 != agent.indexOf("Mozilla")) {
                // 火狐,Chrome等浏览器
                codedFilename = new String(fileNames.getBytes("UTF-8"), "iso-8859-1");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return codedFilename;
    }


	@ApiOperation("导出")
	@GetMapping(value = "/exportTemplate")
	public void exportTemplate(HttpServletRequest request, HttpServletResponse response,
							   @RequestParam Long id) throws IOException {
		Map<String, List<List<String>>> data = service.queryFromDataBase(id);
		String fileName = "test";
		String sheetName = fileName;
		fileName = StringUtil.encodeFileName(fileName, request);
		response.setHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
		response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
		List<List<String>> header = new ArrayList<>();
		List<List<String>> content = new ArrayList<>();
		if (data.get("header") != null && data.get("content") != null)
		{
			header = data.get("header");
			content = data.get("content");
		}
		try {
			EasyExcel.write(response.getOutputStream()).head(header).registerWriteHandler(new CustomHandler())
					.sheet(sheetName).doWrite(content);
		} finally {
			response.getOutputStream().close();
		}
	}