easyexcel写

实体类

public class Province {
    //处理时忽视掉
    @ExcelIgnore
    private Long id;

    @ExcelProperty(value = "省份id",index = 0)
    private BigDecimal provinceId;

    @ExcelProperty(value = "省份名称",index = 1)
    private String provinceName;

    @ExcelProperty(value = "城市id",index = 2)
    private Long cityId;
}

　　写入本地excel文件中

/**
     * 本地的写
     */
    @Test
    void write(){
        /*System.out.println(JSON.toJSONString(provinceMapper.getProvinceList()));*/
        String fileName = "C:/Users/zwk/Desktop/3.xlsx";
        ExcelWriter writer = EasyExcel.write(fileName,Province.class).build();
        WriteSheet writeSheet = EasyExcel.writerSheet("模板").build();
        writer.write(provinceMapper.getProvinceList(),writeSheet );
        writer.finish();
    }

　　web导出数据

@Controller
public class ExcelDemoAction {

    @Autowired
    private ProvinceMapper provinceMapper;

    @RequestMapping("/excelDemo")
    public void excelDemo(HttpServletResponse response)throws Exception{
        
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        String fileName = URLEncoder.encode("测试","UTF-8" );
        //String fileName = "测试"
        response.setHeader("Content-disposition","attachment;filename="+fileName+".xlsx" );
        EasyExcel.write(response.getOutputStream(),Province.class).sheet("模板").doWrite(provinceMapper.getProvinceList());
        response.getOutputStream().close();
    }


}