Easypoi导出功能

红烧牛肉排骨饭

已于 2022-11-29 13:25:00 修改

阅读量271

点赞数

文章标签： java 开发语言

于 2022-11-24 14:52:02 首次发布

本文链接：https://blog.csdn.net/weixin_43762113/article/details/128018447

版权

1.controller 
@Resource
private ExcelExportHandler excelExportHandler;
/**
     * easypoi导出功能
     */
    @ApiOperation(value = "excel导出")
    @PostMapping("/exportExcel")
    public void export(@RequestBody BaseMaterialDto baseMaterialDto,HttpServletResponse response) throws IOException {
        QueryWrapper<BaseMaterial> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name", baseMaterialDto.getName());
        queryWrapper.like("code", baseMaterialDto.getCode());
        queryWrapper.like("storage_room", baseMaterialDto.getStorageRoom());
        List<BaseMaterial> baseMaterials = baseMaterialMapper.selectList(queryWrapper);
        List<MaterialExcelData> data = new ArrayList<>();
        for (int i = 0; i < baseMaterials.size(); i++) {
            MaterialExcelData excelData = new MaterialExcelData();