Exported CSV displying non-english characters currupted

ankurkhunt commented 1 year ago

Hi Team, Hope you are doing well!

Thanks for building this fantastic lib for exporting things easily!

I am facing some issues with non-English characters in the CSV file. I tried various things to convert text into UTF-8 but had no success! Would be great if you can help me to fix the below issue.

I have HTML table which contains these rows

Test Words キャンペーンハイセンスWチャンスフォロー japan プレゼント応募受付テレビ official Kチューナー内蔵液晶ハイセンス臨場感 F ネット動画対応高音質サラウンドシステムお買い得情報 G ネット動画対応 VAパネル ②告知ツイート冷凍庫グローバルブランド冷蔵庫

When we export into csv it shows these in Microsoft Excel: Test Words „Ç≠„É£„É≥„Éö„Éº„É≥ „Éè„Ç§„Çª„É≥„ÇπW„ÉÅ„É£„É≥„Çπ „Éï„Ç©„É≠„Éº japan „Éó„É¨„Çº„É≥„Éà ÂøúÂãüÂèó‰ªò „ÉÜ„É¨„Éì official K„ÉÅ„É•„Éº„Éä„ÉºÂÜÖËîµ Ê∂≤Êô∂ „Éè„Ç§„Çª„É≥„Çπ Ëá®Â†¥ÊÑü F „Éç„ÉÉ„ÉàÂãïÁîªÂØæÂøú È´òÈü≥Ë≥™„Çµ„É©„Ç¶„É≥„Éâ„Ç∑„Çπ„ÉÜ„É† „ÅäË≤∑„ÅÑÂæóÊÉÖÂ†± G „Éç„ÉÉ„ÉàÂãïÁîªÂØæÂøú VA„Éë„Éç„É´ ‚ë°ÂëäÁü•„ÉÑ„Ç§„Éº„Éà ÂÜ∑ÂáçÂ∫´ „Ç∞„É≠„Éº„Éê„É´„Éñ„É©„É≥„Éâ ÂÜ∑ËîµÂ∫´

Sample Screenshot:

Sample CSV file: testCSV.csv

Thanks!

wnabil commented 1 year ago

@ankurkhunt I can see the content of your file correctly without any problems in Visual studio code The Excel app configuration is out of this scope, Try playing with the configuration or contact Microsoft support

wnabil commented 1 year ago

this is also an online tool for viewing csv files and it works https://www.convertcsv.com/csv-viewer-editor.htm

wnabil / ngx-export-as

Exported CSV displying non-english characters currupted #113