search

WeihanLi / WeihanLi.Npoi

NPOI Extensions, excel/csv importer/exporter for IEnumerable<T>/DataTable, fluentapi(great flexibility)/attribute configuration
https://weihanli.github.io/WeihanLi.Npoi/index.html
Apache License 2.0
203 stars 53 forks source link

不能识别纯汉字的日期格式 #144

Closed Pomelo2021 closed 2 years ago

Pomelo2021 commented 2 years ago

二〇二二年一月一日 格式的日期单元格识别为0001/1/1 0:00:00

WeihanLi commented 2 years ago

这种好像识别不出来啊

image

WeihanLi commented 2 years ago

感觉可以通过 InputFormatter 来自定义一个转换逻辑

stale[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

WeihanLi commented 2 years ago

@Pomelo2021 写了一个示例，可以参考这个 commit https://github.com/WeihanLi/WeihanLi.Npoi/commit/f98f624dfc2b2adf56ccd34a7f8964dde53ec291