package org.springblade.modules.yw.excel; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; import com.alibaba.excel.annotation.write.style.ContentRowHeight; import com.alibaba.excel.annotation.write.style.HeadRowHeight; import lombok.Data; import org.springblade.common.excel.ExcelDictConverter; import org.springblade.common.excel.ExcelDictItemLabel; import java.io.Serializable; /** * 企业excel 模板 * @author zhongrj * @date 2024-10-26 */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class ProTarExcel implements Serializable { private static final long serialVersionUID = 1L; @ColumnWidth(20) @ExcelProperty("名称") private String name; @ExcelProperty(value = "归类",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "pro_tar_category") private String category; @ColumnWidth(20) @ExcelProperty("经度") private String lng; @ColumnWidth(20) @ExcelProperty("纬度") private String lat; @ColumnWidth(20) @ExcelProperty("终点经度") private String endLng; @ColumnWidth(20) @ExcelProperty("终点纬度") private String endLat; @ExcelProperty("地址") private String address; @ExcelProperty(value = "类型",converter = ExcelDictConverter.class) @ExcelDictItemLabel(type = "pro_tar_type") private String feature; @ExcelProperty("占地面积(m2)") private Double area; @ExcelProperty("容积(万立方米)") private Double vol; @ExcelProperty("长度(公里)") private Double length; @ExcelProperty("平均流量(立方米/秒)") private Double aveDis; @ExcelProperty("平均流速(米/秒)") private Double aveVel; @ExcelProperty("说明") private String remark; }