EasyExcel数据导出

EasyExcel数据导出，两种方式：1、需要实体类；2、不需要实体类。

<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>easyexcel</artifactId>
   <version>2.1.6</version>
</dependency>

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.support.ExcelTypeEnum;
import com.example.springboottest.entity.UserEntity;
import com.example.springboottest.util.ExcelUtil;
import org.ehcache.shadow.org.terracotta.offheapstore.HashingMap;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.*;

@RestController
public class ExcelExportController {
    //需要实体类
    @GetMapping("/load")
    public void downloadReportData(HttpServletResponse response) {
        String fileName = "测试数据.xls";
        List<UserEntity> userEntities = new ArrayList<>();
        UserEntity userEntity = new UserEntity();
        userEntity.setName("张无忌");
        userEntity.setAccount("9999999999999");
        userEntity.setAddress("光明顶");
        userEntity.setAge(18);
        userEntity.setOccupation("明教教主");
        userEntities.add(userEntity);
        try {
            response.setCharacterEncoding("UTF-8");
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "utf-8"));
            EasyExcel.write(response.getOutputStream(), UserEntity.class).excelType(ExcelTypeEnum.XLS).autoCloseStream(Boolean.TRUE)
                    .sheet("人员信息").doWrite(userEntities);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    // 不需要实体类
    @GetMapping(value = "/export")
    public void export(HttpServletResponse response) throws IOException {
        List<List<String>> heads = new ArrayList<>();
        heads.add(Arrays.asList("姓名"));
        heads.add(Arrays.asList("年龄"));
        heads.add(Arrays.asList("地址"));
        //业务数据存放
        Map<String, Object> m = new HashMap<String, Object>();
        m.put("name", "zwm");
        m.put("age", "18");
        m.put("address", "武汉");
        List<Map<String, Object>> list = new ArrayList<>();
        list.add(m);
        list.add(m);
        list.add(m);
        List<List<Object>> total = new ArrayList<>();
        for (Map<String, Object> map : list) {
            List<Object> info = new ArrayList<>();
            info.add(map.get("name"));
            info.add(map.get("age"));
            info.add(map.get("address"));
            total.add(info);
        }

        String fileName = URLEncoder.encode("人员信息", "UTF-8").replaceAll("\\+", "%20");
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");//设置响应头
        response.setHeader("mime", "application/vnd.ms-excel");

        EasyExcel.write(response.getOutputStream())
                .head(heads)
                .sheet("人员信息")
                .doWrite(total);

    }


}