1.导出的Controller层
/**
* 导出数据
* requestParamDTO
*/
@ApiOperation("导出数据")
@GetMapping("/export")
public void exportData(HttpServletResponse response, RequestParamDTO requestParamDTO) {
templateService.exportExcle(response, requestParamDTO);
}
2.导出Service层实现
/**
* 导出数据
* @param response
* @param requestParamDTO
*/
@Override
public void exportExcle(HttpServletResponse response, RequestParamDTO requestParamDTO) {
if (StringUtils.isEmpty(requestParamDTO.getFileType().toString())) {
throw new RuntimeException("请写入文件类型");
}
// String name = requestParamDTO.getName();//资源名称
String fileName = "导出文件";
String sheetName = "导出文件";
requestParamDTO.setCurrentPage(1);
requestParamDTO.setPageSize(1000000000);
List<FileDTO> list = new ArrayList<>();
FileDTO fileDTO1 = new FileDTO();
if (requestParamDTO.getFileType() == 4l || requestParamDTO.getFileType() == 5l) {
PageSimple pageSimple = wordConfigService.queryByPage(requestParamDTO);
list = pageSimple.getContents();
}
if (requestParamDTO.getFileType() == 2l) {
PageSimpl