sxc2csv - Convert a Star/Open Office SXC (spreadsheet) file to CSV format
sxc2csv [-c] [-o] [-h/-help] [-no_trim]
[-worksheets WORKSHEET_LIST] [-split_sheets]
[-columns COL_LIST] [-dump]
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 any cell that isn't a pure integer.
-no_trim: Do not remove the emtpy cells at the end of
-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
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
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 <firstname.lastname@example.org>
To install OpenOffice::Parse::SXC, copy and paste the appropriate command in to your terminal.
perl -MCPAN -e shell
For more information on module installation, please visit the detailed CPAN module installation guide.