Recent snippets posted on Snipplr.com https://snipplr.com/ Wed, 10 Jun 2026 06:29:49 +0000 https://snipplr.com/view/27342/export-a-single-sheet-of-an-excel-spreadsheet-as-csv-from-the-command-line-with-open-office <p>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"`</p> Fri, 29 Jan 2010 20:28:06 UTC https://snipplr.com/view/27342/export-a-single-sheet-of-an-excel-spreadsheet-as-csv-from-the-command-line-with-open-office