Contribute
0
Answer

Issues while opening a UTF16 encoded .csv file in excel usin

JAGBIR SINGH

JAGBIR SINGH
9y
417
1
Hi all, 

I am trying to open a UTF8(Unicode) encoded .csv file in excel, doing something like this:

m_excel.Workbooks.OpenText(newPath, Comma: true);

And that works fine. Can anyone tell me what to do if i had to open a UTF16 encoded file similarly. Currently using above function overloads either throws all sorts of exception or not printing the unicode characters correctly.

Any help is appreciated. 

Thanks in advance.


Next Recommended Forum