Ask Your Question

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

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

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

edit flag offensive delete link more


Perfect. Thankyou.

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

Question Tools

1 follower


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

Seen: 151 times

Last updated: Aug 03 '18