NAME
sxc2csv - Convert a Star/Open Office SXC (spreadsheet) file to CSV format
SYNOPSIS
sxc2csv [-c] [-o] [-h/-help] [-no_trim]
[-quote_all] [-quote_text]
[-worksheets WORKSHEET_LIST] [-split_sheets]
[-columns COL_LIST] [-dump]
<SXC_FILES>
DESCRIPTION
sxc2csv is used to extract a csv file from an OpenOffice spreadsheet file.
OPTIONS
-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.
WARNINGS
Newlines within cells are removed during the conversion.
MAINTENANCE
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.
AUTHOR
Desmond Lee <deslee@shaw.ca>