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 = "行业类别",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; }