Ask Your Question
0

how to import utf16 csv by macro into calc

asked 2018-08-03 13:33:00 +0100

Aesc gravatar image

I am trying to import a csv via macro

However checking the documentation https://wiki.openoffice.org/wiki/Docu...

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-08-03 13:37:44 +0100

updated 2018-08-03 13:38:52 +0100

Unicode UCS2 is the one you need.

See also https://ask.libreoffice.org/en/questi...

edit flag offensive delete link more

Comments

Perfect. Thankyou.

Aesc gravatar imageAesc ( 2018-08-04 01:42:52 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-03 13:33:00 +0100

Seen: 40 times

Last updated: Aug 03 '18