Component: Table. Export CSV with cyrillic or chinese characters has broken encoding in Microsoft Excel

[AndrewAKovalenko]

Describe the bug

If you have table that consists of cyrillic or chinese symbols, after export CSV you'll have file with broken encoding in Microsoft Excel.

Opening file with Notepad works fine

Input data:

Notepad:

Microsoft Excel:

Environment

Windows

Reproducer

No response

Angular version

17.0.2

PrimeNG version

17.13.2

Build / Runtime

Angular CLI App

Language

TypeScript

Node version (for AoT issues node --version)

20.10.0

Browser(s)

Chrome 120

Steps to reproduce the behavior

1. Go to Table
2. Add cyrillic word to table row (i.e. Тарас Шевченко)
3. Add chinese word (i.e. 成龍)
4. Export CSV from table
5. Open CSV file in Microsoft Excel
6. Open CSV in Notepad
7. Observe result

Expected behavior

Both Notepad and Microsoft Excel shouldn't have problems with encoding symbols