EasyExcel导入50个字段，100万数据耗时几分钟，亲测有效

最新推荐文章于 2024-04-29 22:45:24 发布

北漂青年宋先生

最新推荐文章于 2024-04-29 22:45:24 发布

阅读量607

点赞数

文章标签： java

本文链接：https://blog.csdn.net/qq_41765267/article/details/130259927

版权

public static void main(String[] args) {
   
		String filePath = "D:\\导入模板\1.导入模板.xlsx";
		EasyExcel.read(filePath, Test.class, new TestListener()).readCacheSelector(new SimpleReadCacheSelector(500, 1000)).autoCloseStream(true).sheet().doRead();
	}


/**
 * 导入实体类
 */
public class Test{
   
	private String ORDER_NUM;
	
	private String CREATE_ATIME;
	
	private String SEND_TIME;
	
	private String CONTACT_NUM;
	
	private String CONTACT_NAME;
	
	private String PROBLEM_TITLE;
	
	private String PROBLEM_POINT;
	
	private String ORGAN_NAME;
	
	private String REGION_NAME;
	
	private String TOWN_NAME;
	
	private String PROBLEM_CLASS_ONE;
	
	private String PROBLEM_CLASS_TWO;
	
	private String PROBLEM_CLASS_THREE;
	
	private String FINISH_TIME;
	
	private String DEAL_RESULT;
	
	private String ORDER_CONTENT;
	
	private String REVISITER;
	
	private String REVISIT_NUM;
	
	private String VALID_FLAG;
	
	private String SOLVE_FLAG;
	
	private String SATISFIED_FLAG;
	
	private String CONTACT_FLAG;
	
	private String REVISIT_RESULT;
	
	private String REVISIT_STATUS;
	
	private String ORDER_SOURCE;
	
	private String UNDERTAKE_STATUS;
	
	private String REVISIT_TIME;
	
	private String CALLER;
	
	
	
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String SECRECY_PERSON_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String SECRECY_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String PRAISE_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String INSTABLE_FLAG;
	
	private String REVISIT_SOURCE;
	
	private String INVALID_REASON;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String LESS_REVISIT_TIME_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String ORGAN_NAME_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String ZP_FILE_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String ZZ_FILE_FLAG;
	
	private String ZP_FILE_REMARK;
	
	private String ZZ_FILE_REMARK;
	
	private String ZP_FILE_NAME;
	
	private String ZZ_FILE_NAME;
	
	private String LAST_ORGAN_NAME;
	
	private String QUERY_TIME;
	
	private String ORDER_TYPE;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String CONTACT_REPEAT_FLAG;
	
	@ExcelProperty(value = "",converter = DictConverter.class)
	@DictCode("SY_YESNO")
	private String NO_REPLY_REQUIRED_FLAG;
	
	private String SUB_CENTER_REVISIT_FLAG;
	
	private String SUB_CENTER_SATISFIED_FLAG;
	
	private String FEEDBACK_FLAG;
	
	
	@JSONField(name="NO_REPLY_REQUIRED_FLAG")
	public String getNO_REPLY_REQUIRED_FLAG() {
   
		return NO_REPLY_REQUIRED_FLAG;
	}
	@JSONField(name="SUB_CENTER_REVISIT_FLAG")
	public String getSUB_CENTER_REVISIT_FLAG() {
   
		return SUB_CENTER_REVISIT_FLAG;
	}
	@JSONField(name="SUB_CENTER_SATISFIED_FLAG")
	public String getSUB_CENTER_SATISFIED_FLAG() {
   
		return SUB_CENTER_SATISFIED_FLAG;
	}
	@JSONField(name="FEEDBACK_FLAG")
	public String getFEEDBACK_FLAG() {
   
		return FEEDBACK_FLAG;
	}
	@JSONField(name="ORDER_NUM")