Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to import utf16 csv by macro into calc

I am trying to import a csv via macro

However checking the documentation https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options

i see that utf-8 is listed, but utf16 is not, despite it being available in the open file dialog when opening a csv.

If i use utf8 an extra line is inserted between each row. If i could use utf16 then there would be no empty rows.

Is this possible?