http://snipplr.com/users/softmechanics/tags/basic Recent snippets posted on Snipplr.com en-us Wed, 22 May 2013 11:45:35 GMT http://snipplr.com/view/27342/export-a-single-sheet-of-an-excel-spreadsheet-as-csv-from-the-command-line-with-open-office/ modified from branflake2267's post at oooforum.org: http://www.oooforum.org/forum/viewtopic.phtml?t=52942 usage: Paste into the Standard.Module1 macro file. Then, create xls2csv bash script containing: #!/bin/bash file="$(readlink -f "$1")" /usr/lib/openoffice/program/soffice -invisible -headless -norestore "macro:///Standard.Module1.ConvertXls2Csv(\"$file\", \"$2\")" The first argument is the xls file name, second is the name of the sheet: `xls2csv ./spreadsheet.xls "Some Sheet"`

]]> Fri, 29 Jan 2010 20:28:06 GMT http://snipplr.com/view/27342/export-a-single-sheet-of-an-excel-spreadsheet-as-csv-from-the-command-line-with-open-office/