Encoding to be used while reading CSV

[Robotman (Vivekananda Reddy)]

Hi there,

I have a CSV file with the column names (in Portuguese) as below:

After reading CSV into a data table and write range it into an excel (.xlsx) the columns are appearing as below:

How to avoid this type of characters in Excel file.

There is an encoding property to use while reading CSV if that is the case then suggest me the appropriate code in this case.

Thank you in advance.

[Srini84 (Srinivas)]

@Robotman

Check below thread for your reference

Encode utf-8 csv

Hello community i’m facing the next problem, i download a csv from internet so when i read it and print it i see this [image] the rare element is a accented vowel when i write the csv should i apear á é í ó or ú depending the case so in this case is it necesary to specify encoding propertie to read csv activity? and wich one and how shoul i use ?

Hope this will help you

Thanks

[Yoichi]

Hi,

Can you try “IBM860” ?

Encoding Class (System.Text)

Regards,