/**  * 批注模板式导出（最简实战代码）  * 所有循环、范围逻辑全部写在Excel批注中  */public void exportEmpReport(HttpServletResponse response,   List<Employee> employeeList) throws IOException {    // 设置响应头，解决中文文件名乱码    response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");    response.setHeader("Content-Disposition",   "attachment;filename=员工报表.xlsx");    // 加载模板、绑定数据、写出文件     try (InputStream templateStream =   getClass().getResourceAsStream("/excel/emp_report_tpl.xlsx");     OutputStream outStream =   response.getOutputStream()) {     Context context = new   Context();     // 与模板批注、表达式变量名一一对应     context.putVar("employees", employeeList);     context.putVar("reportDate", LocalDate.now().toString());     // 一行代码完成渲染导出     JxlsHelper.getInstance().processTemplate(templateStream, outStream,   context);   }}

/**  * 编程式配置导出（动态定义报表区域、命令）  * 适合动态调整报表结构、复杂分支场景  */public void exportDynamicReport(HttpServletResponse response,   List<Employee> employeeList) throws IOException {                 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");  response.setHeader("Content-Disposition",   "attachment;filename=动态报表.xlsx");  try (InputStream templateStream = getClass().getResourceAsStream("/excel/dynamic_tpl.xlsx");  OutputStream outStream = response.getOutputStream()) {  // 1. 初始化Jxls处理器  JxlsTransformerFactory   transformerFactory = JxlsTransformerFactory.createPoiFactory();  JxlsProcessor processor = new JxlsProcessor(transformerFactory);  Context context = new   Context();  context.putVar("employees", employeeList);  // 2. 代码手动定义each循环区域：从A4-D4区域循环遍历employees集合  Area area = new   Area("A4", "D4");  // 绑定循环命令  EachCommand eachCommand = new   EachCommand("employees", "employee", area);  // 注册命令到处理器  processor.registerCommand(eachCommand);  // 3. 执行模板渲染导出  processor.process(templateStream, outStream, context); }}