Ask Your Question
0

Convert from CSV to XLSX from console with specific delimiter

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

Exporter gravatar image

updated 2017-06-23 10:52:34 +0200

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 3,182 times

Last updated: Jun 23 '17