sxc2csv - Convert a Star/Open Office SXC (spreadsheet) file to CSV format
sxc2csv [-c] [-o] [-h/-help] [-no_trim] [-quote_all] [-quote_text] [-worksheets WORKSHEET_LIST] [-split_sheets] [-columns COL_LIST] [-dump] <SXC_FILES>
sxc2csv is used to extract a csv file from an OpenOffice spreadsheet file.
-c: Output to STDOUT. -h/-help: Display a help message. -quote_all: Quote EVERY CELL in the csv output. Overrides -quote_text -quote_text: Quote any cell that isn't a pure integer. -no_trim: Do not remove the emtpy cells at the end of each row. -worksheets: Takes one argument - a comma-separated list of the worksheets to convert to csv. Only those worksheets will be processed. eg: -worksheets Sheet1,Sheet2,Sheet3 -split_sheets: Write each worksheet to a separate file. These files are named after the original SXC filename, with the spreadsheet name appended. -columns: Output only these columns, as a comma-separated list of numbers. 0 is the first column. Negative numbers work also, but the results may not be what you expect. eg: -columns 1,4,5 (prints 2nd,5th,6th columns) -dump: Dump the XML tree (XML::Parser::Expat objects). This is used for debugging, but it's also kinda fun.
Newlines within cells are removed during the conversion.
In case this program does not work for your spreadsheet, the problem is likely not here, but in the relatively untried (as of 2003-02) OpenOffice::Parse::SXC module.
Send patches to the email provided below.
Desmond Lee <deslee@shaw.ca>
OpenOffice::Parse::SXC.
To install OpenOffice::Parse::SXC, copy and paste the appropriate command in to your terminal.
cpanm
cpanm OpenOffice::Parse::SXC
CPAN shell
perl -MCPAN -e shell install OpenOffice::Parse::SXC
For more information on module installation, please visit the detailed CPAN module installation guide.