jxls-poi导出excel示例代码文件

package com.jxl.json2excel; import cn.hutool.core.io.FileUtil; import cn.hutool.core.io.file.FileNameUtil; import cn.hutool.json.JSONArray; import cn.hutool.json.JSONObject; import cn.hutool.json.JSONUtil; import org.jxls.common.Context; import org.jxls.util.JxlsHelper; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.context.annotation.Bean; import org.springframework.stereotype.Component; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.File; import java.nio.charset.StandardCharsets; @Component public class App { private static final Logger LOGGER = LoggerFactory.getLogger(App.class); //@Bean public void appRun0() throws Exception { String currentDir = System.getProperty("user.dir") + File.separator; String jsonDir = currentDir + "json" + File.separator; String excelDir = currentDir + "excel" + File.separator; String templateFile = currentDir + "template" + File.separator + "template.xlsx"; LOGGER.info("工作目录：{}", currentDir); for (File json : FileUtil.ls(jsonDir)) { JSONObject jsonObject = JSONUtil.readJSONObject(json, StandardCharsets.UTF_8); try (BufferedInputStream in = FileUtil.getInputStream(templateFile); BufferedOutputStream out = FileUtil.getOutputStream(excelDir + FileNameUtil.mainName(json) + "-output.xlsx")) { Context context = new Context(); // context.putVar("jsonMap", jsonObject.getRaw()); context.putVar("json", jsonObject); context.putVar("util", new ShowUtil()); JxlsHelper.getInstance().processTemplate(in, out, context); } } } @Bean public void appRun1() throws Exception { String currentDir = System.getProperty("user.dir") + File.separator; String jsonDir = currentDir + "json" + File.separator; String excelDir = currentDir + "excel" + File.separator; String templateFile = currentDir + "template" + File.separator + "模板.xlsx"; LOGGER.info("工作目录：{}", currentDir); for (File json : FileUtil.ls(jsonDir)) { JSONArray jsonObject = JSONUtil.readJSONArray(json, StandardCharsets.UTF_8); try (BufferedInputStream in = FileUtil.getInputStream(templateFile); BufferedOutputStream out = FileUtil.getOutputStream(excelDir + FileNameUtil.mainName(json) + "-output.xlsx")) { Context context = new Context(); // context.putVar("jsonMap", jsonObject.getRaw()); context.putVar("json", jsonObject); context.putVar("util", new ExportUtil()); JxlsHelper.getInstance().processTemplate(in, out, context); } } } }