JAGBIR SINGH

JAGBIR SINGH

  • NA
  • 1
  • 732

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

Dec 31 2014 1:32 AM
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.