使用easypoi导出报错java.lang.IllegalArgumentException: firstMovedIndex, lastMovedIndex out of order解决方法
@GetMapping("/exportName")
public void exportName(HttpServletResponse response) throws IOException {
String resource = Objects.requireNonNull(JeecgSystemApplication.class.getClassLoader().getResource("xls/RejectionName.xlsx")).getFile().substring(1);
TemplateExportParams params = new TemplateExportParams(
resource);
Map<String, Object> map = new HashMap<String, Object>();
List<Map<String, Object>> listMap = msManuscriptService.getRejectionName();
map.put("list", listMap);
response.setHeader("content-disposition", "attachment;filename="
+ URLEncoder.encode("aaa.xlsx", "UTF-8"));
ExcelExportUtil.exportExcel(params, map).write(response.getOutputStream());
}
模板位置:
注意模板中设置成fe 而不是$fe:
重新运行即可: