<!--操作excel工具包-->
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>easyexcel</artifactId>
	<version>3.0.5</version>
</dependency>

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
@Data
public class ExcelTitle {
    @ExcelProperty(value="事件名稱", index=0)
    private String eventName;
    @ExcelProperty(value="需求負(fù)責(zé)人", index=1)
    private String prdManager;
    @ExcelProperty(value="技術(shù)負(fù)責(zé)人", index=2)
    private String techManager;
    @ExcelProperty(value="文檔鏈接", index=3)
    private String prdDocs;
    @ExcelProperty(value="數(shù)據(jù)鏈接", index=4)
    private String statsDocs;
    @ExcelProperty(value="統(tǒng)計(jì)口徑", index=5)
    private String reportCaliber;

@RequestMapping(value = "/bulkOutput", method = RequestMethod.GET)
    public ResultBean bulkOutput(HttpServletResponse response) {
        // 重要! 設(shè)置返回格式是excel形式
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        // 設(shè)置編碼格式
        response.setCharacterEncoding("utf-8");
        // 設(shè)置URLEncoder.encode 防止中文亂碼
        String fileName = null;
        try {
            fileName = URLEncoder.encode("數(shù)據(jù)批量導(dǎo)出", "UTF-8").replaceAll("\\+", "%20");
        // 設(shè)置響應(yīng)頭
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
        List<ExcelTitle> bulkOutputData = wildEventService.getBulkOutputData();
        // 模板文件保存在springboot項(xiàng)目的resources/static下
        Resource resource = new ClassPathResource("static/數(shù)據(jù)批量導(dǎo)出模板.xlsx");
        ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream())
            							   .withTemplate(resource.getInputStream())	// 利用模板的輸出流
            							   .build();
        // 寫入模板文件的第一個(gè)sheet 索引0    
        WriteSheet writeSheet = EasyExcel.writerSheet(0).build();
        // 將數(shù)據(jù)寫入到模板文件的對(duì)應(yīng)sheet中
        excelWriter.write(bulkOutputData, writeSheet);
        excelWriter.finish();
        } catch (UnsupportedEncodingException e) {
            return ResultBean.errorService(e.getMessage());
        } catch (IOException e) {
            return ResultBean.errorService(e.getMessage());
        }
        return ResultBean.success("數(shù)據(jù)導(dǎo)出成功!");
    }

import com.example.demo.Pojo.ExcelTitle;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.List;
@Service
public class BulkOutputService {
    public List<ExcelTitle> getOutputData()
    {
        List<ExcelTitle> resultList = new ArrayList<>();
        // 第一行數(shù)據(jù)
        ExcelTitle t1 = new ExcelTitle();
        t1.setEventName("測(cè)試數(shù)據(jù)1");
        t1.setTechManager("張三");
        t1.setPrdManager("張三");
        t1.setPrdDocs("http://prdDocs.com");
        t1.setStatsDocs("http://statsDocs.com");
        t1.setReportCaliber("reportCaliber");
        // 第二行數(shù)據(jù)
        ExcelTitle t2 = new ExcelTitle();
        t2.setEventName("測(cè)試數(shù)據(jù)2");
        t2.setTechManager("李四");
        t2.setPrdManager("李四");
        t2.setPrdDocs("http://prdDocs.com");
        t2.setStatsDocs("http://statsDocs.com");
        t2.setReportCaliber("reportCaliber");
        resultList.add(t1);
        resultList.add(t2);
        return resultList;
    }
}