Desmond Lee > OpenOffice-Parse-SXC > sxc2csv

Download:
OpenOffice-Parse-SXC-0.03.tar.gz

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Source  

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.

syntax highlighting: