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

issue_ csv乱码 #40

Closed
adminlove520 opened this issue Dec 3, 2023 · 3 comments
Closed

issue_ csv乱码 #40

adminlove520 opened this issue Dec 3, 2023 · 3 comments

Comments

@adminlove520
Copy link

Describe the bug
A clear and concise description of what the bug is.
导出csv时,会出现乱码的情况 ,师父是不是创建文件时候忘记utf-8啦
并且 在csv内也会出现重复消息的情况
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.
image

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.

@LC044
Copy link
Owner

LC044 commented Dec 3, 2023

他是utf-8格式的,是你的CSV查看器以gbk编码打开了这个CSV,所以会出现乱码,不信你用记事本打开看看,或者vscode

@LC044 LC044 closed this as completed Dec 3, 2023
@adminlove520
Copy link
Author

是这样的 有一个解决方案:
新建一个xlsx,数据-从文本/csv-选择导出的csv(原始格式要选utf-8,原始的是1252:西欧),然后转换数据;然后关闭并上载就可以转换成正常Excel格式的了
/** 转换后:/
image
/
转换前: **/
image

@adminlove520
Copy link
Author

然后就是去重的问题

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants