Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

2.1.0版本，从excel导入数据，不识别日期格式 #68

Closed
zhujinhu21 opened this issue Mar 25, 2020 · 15 comments
Closed

2.1.0版本，从excel导入数据，不识别日期格式 #68

zhujinhu21 opened this issue Mar 25, 2020 · 15 comments
Assignees
@xin-lai
Labels
bug Something isn't working
Milestone
2.2

Comments

@zhujinhu21
Copy link

zhujinhu21 commented Mar 25, 2020 •
edited

Describe the bug
A clear and concise description of what the bug is.
excel中 列是日期格式，导入报错，提示“值 43914 无效，请填写正确的日期时间格式！”
To Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.
微信截图_20200325165247

Desktop (please complete the following information):

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]

Smartphone (please complete the following information):

  • Device: [e.g. iPhone6]
  • OS: [e.g. iOS8.1]
  • Browser [e.g. stock browser, safari]
  • Version [e.g. 22]

Additional context
Add any other context about the problem here.
@hueifeng hueifeng added the bug Something isn't working label Mar 25, 2020
@xin-lai
Copy link
Collaborator

xin-lai commented Mar 25, 2020

问题已收到，正在处理。目前发现线上的单元测试是OK的，但是本地单元测试确实没有通过，原因已经找到，我们会尽快处理并发布Beta版。

@zhujinhu21
Copy link
Author

netcore2.2的项目不能使用 Magicodes.IE.Excel 2.1.0以上的版本。nuget添加失败

xin-lai pushed a commit that referenced this issue Mar 25, 2020
@codelove1314
#### **2020.03.25**
554ac93 
- **【Nuget】版本更新到2.2.0-beta3**
- **【Excel导入】修复日期问题 [#68](#68
- **【Excel导出】添加ExcelOutputType设置，支持输出无格式的导出。[#54](#54
xin-lai pushed a commit that referenced this issue Mar 25, 2020
@codelove1314
#### **2020.03.25**
e93da88 
- **【Nuget】版本更新到2.2.0-beta3**
- **【Excel导入】修复日期问题 [#68](#68
- **【Excel导出】添加ExcelOutputType设置，支持输出无格式的导出。[#54](#54
@xin-lai
Copy link
Collaborator

xin-lai commented Mar 26, 2020

试试2.2 Beta版的包

@xin-lai xin-lai mentioned this issue Mar 26, 2020
Closed
@xin-lai
Copy link
Collaborator

xin-lai commented Mar 26, 2020

刚试过2.1.4版本没有问题。

@xin-lai xin-lai closed this as completed Mar 26, 2020
@zhujinhu21
Copy link
Author

zhujinhu21 commented Mar 26, 2020 •
edited

netcore2.2 不能使用2.1.4以上的包，我直接使用下载的源码

@xin-lai
Copy link
Collaborator

xin-lai commented Mar 26, 2020

是Beta版的不支持么？.net core 2.2我试过用2.1.4可以啊。

@xin-lai xin-lai reopened this Mar 26, 2020
@zhujinhu21
Copy link
Author

我是webapi项目 ,目标框架 netcore 2.2 ,vs2017工具

PM> Install-Package Magicodes.IE.Excel -Version 2.1.4
正在还原 D:\Work\isolate_user\room_user\api\cov19_api\cov19_api\cov19_api.csproj 的包...
Install-Package : NU1107: Microsoft.Extensions.Configuration 中检测到版本冲突。直接安装/引用 Microsoft.Extensions.Configuration 3.1.0 到项目 cov19_api 可解决此问题。
cov19_api -> Magicodes.IE.Excel 2.1.4 -> EPPlus 4.5.3.3 -> Microsoft.Extensions.Configuration.Json 3.1.0 -> Microsoft.Extensions.Configuration (>= 3.1.0)
cov19_api -> Microsoft.AspNetCore.App 2.2.0 -> Microsoft.Extensions.Configuration (>= 2.2.0 && < 2.3.0).
所在位置 行:1 字符: 1

  • Install-Package Magicodes.IE.Excel -Version 2.1.4
  •   + CategoryInfo          : NotSpecified: (:) [Install-Package], Exception
  + FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PackageManagement.PowerShellCmdlets.InstallPackageCommand

Install-Package : 程序包还原失败。正在回滚“cov19_api”的程序包更改。
所在位置 行:1 字符: 1

  • Install-Package Magicodes.IE.Excel -Version 2.1.4
  •   + CategoryInfo          : NotSpecified: (:) [Install-Package], Exception
  + FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PackageManagement.PowerShellCmdlets.InstallPackageCommand

@zhujinhu21
Copy link
Author

zhujinhu21 commented Mar 26, 2020 •
edited

ConsoleApp5.zip

其中的WebApplication1项目不能添加Magicodes.IE.Excel 2.1.4

@xin-lai
Copy link
Collaborator

xin-lai commented Mar 27, 2020

收到。

@xin-lai xin-lai self-assigned this Mar 27, 2020
@xin-lai xin-lai added this to the 2.2 milestone Mar 27, 2020
@xin-lai
Copy link
Collaborator

xin-lai commented Mar 27, 2020

这是EPPlus的坑，已解决：

Install-Package Magicodes.IE.Excel -Version 2.2.0-beta5

@xin-lai xin-lai closed this as completed Mar 27, 2020
@zhujinhu21
Copy link
Author

zhujinhu21 commented Mar 27, 2020 •
edited

用2.2.0-beta5从excel导入数据报错

System.Drawing.Common 要用System.Drawing.Common (>= 4.6.0-preview6.19303.8)的包才行，4.7.0包找不到dll
ConsoleApp5.zip
里面valuescontroller是个测试

@xin-lai
Copy link
Collaborator

xin-lai commented Mar 27, 2020 •
edited

已经找到原因，将尽快处理

@xin-lai xin-lai reopened this Mar 27, 2020
@xin-lai
Copy link
Collaborator

xin-lai commented Mar 27, 2020

https://www.nuget.org/packages/Magicodes.IE.Excel/2.2.0-beta6
好了，请使用 2.2.0-beta6

@xin-lai
Copy link
Collaborator

xin-lai commented Mar 27, 2020

Install-Package Magicodes.IE.Excel -Version 2.2.0-beta6

@zhujinhu21
Copy link
Author

ok，谢谢

xin-lai pushed a commit that referenced this issue Mar 27, 2020
@codelove1314
- **【Nuget】版本更新到2.2.0-beta6**
837b324 
- **【Excel导入导出】修复.NET Core 2.2的包引用问题 [#68](#68
This was referenced Jun 16, 2020
Closed
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@xin-lai xin-lai

Labels
bug Something isn't working
Projects
None yet
Milestone
2.2
Development

No branches or pull requests
3 participants
@zhujinhu21 @xin-lai @hueifeng