java 导出功能
出现错误的原因是: 实体中存在日期,而导出的时候Excel无法转换日期类型。
解决方法:
在实体中将日期类型转换为String类型:
@ColumnWidth(25)
@ExcelProperty(value="计划开始日期",index=14)
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER)
private String planStartDateStr;
@ColumnWidth(25)
@ExcelProperty(value="计划结束日期",index=15)
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER)
private String planEndDateStr;
private Date planStartDate;
private Date planEndDate;
public void setting() {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
if (null != planStartDate) {
planStartDateStr = sdf.format(planStartDate);
}
if (null != planEndDate) {
planEndDateStr = sdf.format(planEndDate);
}
}