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;
|
}
|
