@GetMapping("/exportExcel")
public void exportExcel(HttpServletResponse response) throws IOException {
QueryWrapper<DtbsItem> objectQueryWrapper = new QueryWrapper<>();
List<DtbsItem> itemLibraryVos = itemsMapper.selectList(objectQueryWrapper);
System.out.println(itemLibraryVos);
//设置导出格式
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
//导出数据 DtbsItem为实体类 itemLibraryVos 为数据库中查出的数据
EasyExcel.write(response.getOutputStream(), DtbsItem.class).sheet("品规信息表").doWrite(itemLibraryVos);
}
Easyexcel 导出excel
最新推荐文章于 2024-06-03 15:08:51 发布