package org.springblade.modules.yw.excel;
|
|
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.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 FirmInfoExcel implements Serializable {
|
private static final long serialVersionUID = 1L;
|
|
@ColumnWidth(20)
|
@ExcelProperty("企业名称")
|
private String name;
|
|
@ColumnWidth(20)
|
@ExcelProperty("经度")
|
private String lng;
|
|
@ColumnWidth(20)
|
@ExcelProperty("纬度")
|
private String lat;
|
|
@ExcelProperty("地址")
|
private String address;
|
|
@ColumnWidth(20)
|
@ExcelProperty(value = "行业类别")
|
// @ExcelProperty(value = "行业类别",converter = ExcelDictConverter.class)
|
// @ExcelDictItemLabel(type = "industry_category")
|
private String category;
|
|
@ExcelProperty("应急联络人")
|
private String personInCha;
|
|
@ExcelProperty("应急联络人电话")
|
private String personInChaPhone;
|
|
@ExcelProperty("主要产品")
|
private String mainProduct;
|
|
@ExcelProperty("备注")
|
private String remark;
|
}
|