How to import utf16 csv by macro into calc

English
, , ,
#1

I am trying to import a csv via macro

However checking the documentation Filter Options - Apache OpenOffice Wiki

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?

#2

Unicode UCS2 is the one you need.

See also Convert-to from csv to ods and viceversa

#3

Perfect. Thankyou.

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.