Ask Your Question
0

Convert from CSV to XLSX from console with specific delimiter [closed]

asked 2017-06-23 10:40:31 +0100

Exporter gravatar image

updated 2020-08-04 18:03:49 +0100

Alex Kemp gravatar image

Hey everyone,

I can already convert from CSV to XLSX via command line on Windows 7 thanks to this post, but it only uses a comma (,) as delimiter.

My current command looks like this:
start /wait soffice --headless --convert-to xlsx:"Calc MS Excel 2007 XML" file_to_convert.csv

I already tried it with specific filter options, but they only seem to work when any format is convertet to CSV
start /wait soffice --convert-to xlsx:"Calc MS Excel 2007 XML":59/9,34,0,1,1 "file_to_convert.csv"

Do you have any advice how to use tabs and/or semicolon(;) as a delimiter during this conversion?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-04 18:04:00.691342

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-23 10:52:08 +0100

You need to use --infilter command line option with CSV filter options, like shown e.g. here.

edit flag offensive delete link more

Comments

Thank you for the fast response, it works great

Exporter gravatar imageExporter ( 2017-06-23 11:02:22 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-06-23 10:40:31 +0100

Seen: 5,701 times

Last updated: Jun 23 '17