haoyang7 commented on issue #663:
URL: https://github.com/apache/fesod/issues/663#issuecomment-3465780508
定位到了，使用了spring的异步线程，异常日志被吞掉了，日志是这样的
Exception in thread "main"
cn.idev.excel.exception.ExcelWriteDataConvertException: Can not find
'Converter' support class Timestamp.
at
cn.idev.excel.write.executor.AbstractExcelWriteExecutor.doConvert(AbstractExcelWriteExecutor.java:339)
at
cn.idev.excel.write.executor.AbstractExcelWriteExecutor.convert(AbstractExcelWriteExecutor.java:287)
at
cn.idev.excel.write.executor.AbstractExcelWriteExecutor.converterAndSet(AbstractExcelWriteExecutor.java:56)
at
cn.idev.excel.write.executor.ExcelWriteAddExecutor.doAddBasicTypeToExcel(ExcelWriteAddExecutor.java:140)
at
cn.idev.excel.write.executor.ExcelWriteAddExecutor.addBasicTypeToExcel(ExcelWriteAddExecutor.java:98)
at
cn.idev.excel.write.executor.ExcelWriteAddExecutor.addOneRowOfDataToExcel(ExcelWriteAddExecutor.java:74)
at
cn.idev.excel.write.executor.ExcelWriteAddExecutor.add(ExcelWriteAddExecutor.java:55)
at
cn.idev.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:57)
at cn.idev.excel.ExcelWriter.write(ExcelWriter.java:70)
at cn.idev.excel.ExcelWriter.write(ExcelWriter.java:47)
可能1.3.0版本修改了 #322 ，
public class App {
public static void main(String[] args) {
System.out.println("Hello World!");
writeWithNoPOJO();
System.out.println("Done...");
}
static void writeWithNoPOJO() {
File path = new
File("/Users/yanghao/IdeaProjects/shufang/dev/uploadPath/multi-sheet-list-write-test.xlsx");
List<List<String>> head = new ArrayList<>();
head.add(List.of("序号"));
head.add(List.of("代码"));
head.add(List.of("时间"));
try (ExcelWriter excelWriter =
FastExcel.write(path).excelType(ExcelTypeEnum.XLSX).build()) {
for (int i = 0; i < 3; i++) {
WriteSheet writeSheet = FastExcel.writerSheet(i,
"TableName_" + (i + 1))
.head(head)
.registerConverter(new TimestampConverter())
.build();
excelWriter.write(mapData(), writeSheet);
}
}
}
public static List<List<Object>> mapData() {
return IntStream.range(1, 11)
.<List<Object>>mapToObj(no -> List.of(no,
UUID.randomUUID().toString(), new Timestamp(System.currentTimeMillis())))
.toList();
}
}
public class TimestampConverter implements Converter<Timestamp> {
@Override
public Class<Timestamp> supportJavaTypeKey() {
return Timestamp.class;
}
@Override
public CellDataTypeEnum supportExcelTypeKey() {
return CellDataTypeEnum.STRING;
}
@Override
public WriteCellData<String> convertToExcelData(Timestamp timestamp,
ExcelContentProperty contentProperty,
GlobalConfiguration
globalConfiguration) throws Exception {
return new
WriteCellData<String>(FastDateFormat.getInstance("yyyy-MM-dd").format(timestamp));
}
}
@delei @bengbengbalabalabeng
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
