Skip to content

Instantly share code, notes, and snippets.

@digitalist

digitalist/soffice.convert2csv.sh

Created November 9, 2017 12:19
Show Gist options
  • Save digitalist/38196cf3946c0e065c6d4f7affb0f7d3 to your computer and use it in GitHub Desktop.
Save digitalist/38196cf3946c0e065c6d4f7affb0f7d3 to your computer and use it in GitHub Desktop.
Download ZIP
cheat-file for soffice spreadsheet (xls/ods) to csv conversion
Raw
soffice.convert2csv.sh
#!/usr/bin/env bash
#soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":44,34,76,1,,true,false jira_csv/OrgPerson.ods
#params explained:
# https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options#Filter_Options_for_the_CSV_Filter
#44, #1, the ASCII code for the separator
#34, #2, text quoting (34 is ", 44 is ' and so on..)
#76, #3, utf8
#1 #4,
#, #5, field delimiter default
#, #6, text delimiter default
#true, #7, quote all fields
#false #8, disable 'save cell contents as shown', save raw contents
soffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":44,34,76,1,,true,false $1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment