vue easyexcel 导出excel post请求接参数
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>3.0.5</version>
</dependency>
controller
@PostMapping("/list/export")
public void exportProductionStopList(
@RequestBody(required = false) ProductionStopInfoDTO productionStopInfoDTO, HttpServletResponse response) throws Exception {
try {
productionStopService.exportProductionStopList(productionStopInfoDTO, response);
}catch (Exception e){
logger.error("导出失败", e);
// 重置response
response.reset();
response.setContentType("application/json");
response.setCharacterEncoding("utf-8");
Map<String, String> map = MapUtils.newHashMap();
map.put("status", "failure");
map.put("message", "下载文件失败" + e.getMessage());
response.getWriter().println(JSON.toJSONString(map));
}
}
service
@Override public void exportProductionStopList(ProductionStopInfoDTO productionStopInfoDTO, HttpServletResponse response) throws Exception {
//查询条件 QueryWrapper<Object> wrapper = getObjectQueryWrapper(productionStopInfoDTO); ArrayList<ProductionStopListVO> pageList = productionStopInfoMapper.queryProductionStopList(wrapper); //+ DateUtil.getCurrentDateStr("yyyyMMddHHmmss") setExcelRespProp(response, "某个列表"); pageList.stream().map(v -> { ProductionStopListVO productionStopListVO = (ProductionStopListVO) v; productionStopListVO.setStatusName(ProductionStopStatusEnum.getProductionStopStatus(productionStopListVO.getStatus())); return productionStopListVO; }).collect(Collectors.toList()); EasyExcel.write(response.getOutputStream(),ProductionStopListVO.class) .sheet("sheet1") .doWrite(pageList); } /** * 设置excel下载响应头属性 */ private void setExcelRespProp(HttpServletResponse response, String rawFileName) throws UnsupportedEncodingException { response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); String fileName = URLEncoder.encode(rawFileName, "UTF-8").replaceAll("\\+", "%20"); response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); }
model
import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.qm.be.util.excel.LocalDateStringConverter;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;
import java.time.LocalDate;
@Data @HeadRowHeight(20) public class ProductionStopListVO { /** * id */ @ExcelIgnore private String id; /** * 生产关闭编号 */ @ExcelProperty("生产关闭编号") @ColumnWidth(25) private String productionStopNo; /** * 产品类别 */ @ExcelProperty("产品类别") private String productCategory; /** * 产品家族 */ @ExcelProperty("产品家族") @ColumnWidth(15) private String productionFamily; /** * 负责人 */ @ExcelProperty("负责人") @ColumnWidth(15) private String ownerName; /** * 申请日期 */ @ExcelProperty(value ="申请日期" ,converter = LocalDateStringConverter.class) @DateTimeFormat(pattern = "yyyy-MM-dd") @JsonFormat(pattern="yyyy-MM-dd") @ColumnWidth(15) private LocalDate createTime; /** * 状态名称 */ @ExcelProperty("状态") private String statusName; /** * 状态 */ @ExcelIgnore private Integer status; /** * 故障描述 */ @ExcelProperty("故障描述") @ColumnWidth(25) private String failureDescription; }
自定义时间转换
package com.qm.be.util.excel; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.enums.CellDataTypeEnum; import com.alibaba.excel.metadata.GlobalConfiguration; import com.alibaba.excel.metadata.data.ReadCellData; import com.alibaba.excel.metadata.data.WriteCellData; import com.alibaba.excel.metadata.property.ExcelContentProperty; import java.time.LocalDate; import java.time.format.DateTimeFormatter; public class LocalDateStringConverter implements Converter<LocalDate> { @Override public Class<?> supportJavaTypeKey() { return LocalDate.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } @Override public LocalDate convertToJavaData(ReadCellData<?> cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { return LocalDate.parse(cellData.getStringValue(), DateTimeFormatter.ofPattern("yyyy-MM-dd")); } @Override public WriteCellData<?> convertToExcelData(LocalDate value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); String format = formatter.format(value); return new WriteCellData(format); } }
package com.qm.be.util.excel; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.enums.CellDataTypeEnum; import com.alibaba.excel.metadata.GlobalConfiguration; import com.alibaba.excel.metadata.data.ReadCellData; import com.alibaba.excel.metadata.data.WriteCellData; import com.alibaba.excel.metadata.property.ExcelContentProperty; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; public class LocalDateTimeStringConverter implements Converter<LocalDateTime> { @Override public Class<?> supportJavaTypeKey() { return LocalDateTime.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } @Override public LocalDateTime convertToJavaData(ReadCellData<?> cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { return LocalDateTime.parse(cellData.getStringValue(), DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); } @Override public WriteCellData<?> convertToExcelData(LocalDateTime value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); String format = formatter.format(value); return new WriteCellData(format); } }
vue
const requestExportList = (url, data) => { return new Promise((resolve, reject) => { axios.post(url, data, { responseType: "blob" }).then( res => { // debugger; const link = document.createElement("a"); const blob = new Blob([res.data], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }); link.style.display = "none"; link.href = URL.createObjectURL(blob); link.download = "某个列表.xlsx"; document.body.appendChild(link); link.click(); document.body.removeChild(link); resolve(); }, err => { reject(err); } ); }); }; const exportList = async () => { let createTimeStart = ""; let createTimeEnd = ""; // debugger; if (pageParams.timeline == null) { pageParams.timeline = []; } if (pageParams.timeline.length > 0) { createTimeStart = pageParams.timeline[0]; createTimeEnd = pageParams.timeline[1]; } // let res = await exportProductionStopList({}); // debugger; let rLoading = openLoading(); await requestExportList("/接口/list/export", { createTimeStart: createTimeStart, createTimeEnd: createTimeEnd, status: pageParams.status != "" ? parseInt(pageParams.status) : "", productFamily: pageParams.productFamily }) .then(res => {}) .finally(() => { rLoading.close(); }); // debugger; };
