Save CSV to UTF-8

Ui.Vision
1

Hey guys!
I have a Macro that runs on a platform that extracts information from the screen and saves it in a CSV. I wanted to know if it is possible to download the CSV file in UTF-8, since the format that the special characters come in is buggy and has an error (I’m from Brazil).
Uivision
erro 1

Excel

erro 2

2

Actually, Ui.vision uses UTF-8 by default. Are you sure the problem is in the downloaded file, and does not happen during the Excel import?

3

No, I use it on the web and it comes out in the format “Microsoft Excel Comma separated Values ​​File” and it comes out with buggy special characters. I tried to record a video to show, but it doesn’t record alternative screens, I don’t know why. so I’m sending a print of the format that is saved.

Captura de tela 2024-09-25 183613
Captura de tela 2024-09-25 1836131295×119 2.76 KB

4

Please see this test macro - if you run it, is the saved CSV with unicode? It should be.

5

Below are prints with the macro response. had the same problem.

Teste 1
Teste 11008×302 13.2 KB

teste 1 2
teste 1 3
teste 1 31339×152 3.68 KB

Teste 1 4
Teste 1 4762×279 18.1 KB

6

The test macro works for me. Here a test with Notepad++, which uses unicode by default:

unicode
unicode1152×842 139 KB

7

The issue is with Excel. → You need to change the Excel settings.

Excel does not use Unicode by default:

excel does not load CSV in unicode by default
excel does not load CSV in unicode by default721×413 84.8 KB

8

Thanks!
That way it worked.
You are AMAZING!

1 Like