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>

SEE ALSO

OpenOffice::Parse::SXC.