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.