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

结果csv文件中文乱码 #22

Closed
xiaoheiwo opened this issue Sep 18, 2019 · 6 comments
Closed

结果csv文件中文乱码 #22

xiaoheiwo opened this issue Sep 18, 2019 · 6 comments
Assignees
Labels
bug Something isn't working

Comments

@xiaoheiwo
Copy link

是否使用了最新代码
是或否(如果不是的话尝试克隆最新的代码再跑一下)

Bug描述
清晰而简洁的Bug描述

cvs结果文件 中文乱码

如何复现
复现步骤(可不写)
复现命令

预期结果
清晰而简洁的预期结果描述(可不写)

实际结果
清晰而简洁的实际结果描述(如出现什么错误)
打开cvs结果 中文都是乱码
屏幕截图

image

运行环境

  • 系统:[例如Windows 10 x64]
  • Python版本:[例如3.7.1]
  • OneForAll版本:[例如0.0.6]

报错文本
复制完整的报错文本

@xiaoheiwo xiaoheiwo added the bug Something isn't working label Sep 18, 2019
@shmilylty
Copy link
Owner

@shmilylty
Copy link
Owner

shmilylty commented Sep 18, 2019

Q:使用Excel打开结果的csv中有中文乱码,怎么解决?

A:由于Excel打开文件需要带BOM头识别编码,而默认生成的结果csv文件是UTF-8编码不是UTF-8-BOM,所以会使用Excel打开会出现中文乱码,有以下解决办法:

1.使用NotePad++类似工具转化编码格式为UTF-8-BOM。

2.使用Excel软件导入结果csv文件中的数据。

@shmilylty shmilylty pinned this issue Feb 23, 2020
@ghost
Copy link

ghost commented Jun 11, 2020

强!管用!

@fatmeat
Copy link

fatmeat commented Dec 26, 2020

Does not support xls format 怎麼不行呢, xlsx也一樣

@shmilylty
Copy link
Owner

Does not support xls format 怎麼不行呢, xlsx也一樣

现在不支持xls和xlsx格式导出了

@shmilylty
Copy link
Owner

使用最新仓库代码可解决此问题

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants