一个系统,涉及导出功能的需求是非常多的,需要设计一个工具类,提供给常规导出功能所需,减少代码量。展示相关的excel工具类
举个实例:
controller层
@RestController
@Slf4j
public class PpmExportDataController {@AutowiredIPpmExportDataService ppmExportDataService;@PostMapping("/MpowerPPMService/getExcelData")public void getExcelData(@RequestBody MpowerPpmQueryParam queryParam,HttpServletResponse response) {ExcelSheet<Object> excelSheet = ppmExportDataService.getExcelData(queryParam);File file = new File(excelSheet.getSheetName());// 设置响应的头和客户端保存的文件名response.setCharacterEncoding("UTF-8");response.setContentType("application/octet-stream");response.setHeader("Content-Disposition", "attachment;fileName=" + file.getName());try (