ExcelHelper.ToDataTable 报 Cannot get a text value from a numeric cell

Question

ExcelHelper.ToDataTable 报 Cannot get a text value from a numeric cell

zl33842901 opened this issue 5 years ago · 5 comments

InvalidOperationException: Cannot get a text value from a numeric cell

DataTable dataTable=ExcelHelper.ToDataTable(saveFileName);

Answer 1 · 2019-11-05T03:06:46.000Z

Issue-Label Bot is automatically applying the label bug to this issue, with a confidence of 0.95. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

Answer 2 · 2019-11-05T03:26:07.000Z

Thanks for your feedback, I'll try to solve it as soon as possible.

Answer 3 · 2019-11-05T05:27:36.000Z

Could you please provide a demo to reproduce? Sorry that I can not reproduce this problem

Answer 4 · 2019-11-06T01:38:04.000Z

@zl33842901 能否提供一个可重现这个问题的简单示例？我这里测试的没有问题，

测试代码： https://github.com/WeihanLi/WeihanLi.Npoi/blob/dev/samples/DotNetCoreSample/Program.cs#L64

Answer 5 · 2019-12-06T01:51:24.000Z

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.