EasyExcel实用技巧

最新推荐文章于 2024-08-03 20:59:19 发布

「已注销」

最新推荐文章于 2024-08-03 20:59:19 发布

阅读量235

点赞数

分类专栏：工作笔记文章标签： java servlet 前端

本文链接：https://blog.csdn.net/qq_41588302/article/details/125977569

版权

工作笔记专栏收录该内容

22 篇文章 0 订阅

订阅专栏

下载,上传excel

/**
	模板下载(用的poi的）
*/
ClassPathResource resource = new ClassPathResource("template/企业信息模板.xlsx");
String path = resource.getURL().getPath();
path = URLDecoder.decode(path, "UTF-8");
File file = new File(path);
Workbook workbook = new XSSFWorkbook(file);
response.setCharacterEncoding("UTF-8");
response.setContentType("application/octet-stream;charset=utf-8");
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
workbook.write(response.getOutputStream());
/**
	导出数据
*/
@GetMapping("download")
public void download(HttpServletResponse response) throws IOException {
    response.setContentType("application/vnd.ms-excel");
    response.setCharacterEncoding("utf-8");
 response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
    EasyExcel.write(response.getOutputStream(), xx.class).sheet("模板").doWrite(List);
}

/**
	excel文件的上传
*/
@PostMapping("upload")
@ResponseBody
public String upload(MultipartFile file) throws IOException {
    EasyExcel.read(file.getInputStream(), DemoData.class, new DemoDataListener()).sheet().doRead();
    return "success";
}

读取数据

InputStream inputStream = multipartFile.getInputStream();
      List<ExcelImportTktEntInfoVo> list = EasyExcel.read(inputStream).head(ExcelImportTktEntInfoVo.class).sheet().doReadSync();

注解

@ColumnWidth(30)
public class ExcelExportTktInfoVo {
    @ExcelIgnore
    private String esopEnterpriseId;
    @ExcelProperty("地市")
    private String busiRegCityName;
    }