excel轻便导出

1、依赖支持 

<!-- AutoPoi Excel工具类-->
        <dependency>
            <groupId>org.jeecgframework</groupId>
            <artifactId>autopoi-web</artifactId>
            <version>1.2</version>
            <exclusions>
                <exclusion>
                    <groupId>commons-codec</groupId>
                    <artifactId>commons-codec</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

2、POJO类

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.jeecgframework.poi.excel.annotation.Excel;

import java.math.BigDecimal;
import java.sql.Date;

/**
 * @author 
 * @description
 * @date 2021/11/17 8:52
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class EmpVo2 {
    @Excel(name = "员工编号",width = 15)
    private Integer empno;
    @Excel(name = "员工名称",width = 15)
    private String ename;
    @Excel(name = "工作",width = 15)
    private String job;
    @Excel(name = "职位编码",width = 15)
    private Integer mgr;
    @Excel(name = "入职日期",width = 15)
    private Date hiredate;
    @Excel(name = "津贴",width = 15)
    private BigDecimal sal;
    @Excel(name = "基本工资",width = 15)
    private BigDecimal comm;
    @Excel(name = "部门编号",width = 15)
    private Integer deptno;
}

3、Controller

import com.study.common.utils.BaseController;
import com.study.entity.vo.EmpVo;
import com.study.service.EmpService;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletResponse;
import java.util.List;


@RestController
@RequestMapping("/emp")
public class EmpController extends BaseController {
    
    //构造方法注入
    private final EmpService empService;

    public EmpController(EmpService empService) {
        this.empService = empService;
    }

    @GetMapping("/exportEmp")
    public ModelAndView exportEmp(
            @RequestParam(value = "name",required = false)
            String name){
        ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
        //获取的数据
        List<EmpVo> list = empService.findEmpByName(name);
        //文件名称
        mv.addObject(NormalExcelConstants.FILE_NAME,"jeecg导出功能");
        //文件映射对象（选择使用到的@Excel对象POJO）
        mv.addObject(NormalExcelConstants.CLASS, EmpVo.class);
        //关于ExportParams有很多构造方法
        //当前选择的是第一行名称是【jeecg导出功能2】、sheel名字是【员工信息】
        mv.addObject(NormalExcelConstants.PARAMS, 
    new ExportParams("jeecg导出功能2", "员工信息"));
        //数据对象
        mv.addObject(NormalExcelConstants.DATA_LIST, list);
        return mv;
    }
}

4、效果图

 

有疑问或者需要出哪些方面的文章可以在下方评论区留言！