Please login to access the resource

Extract OpenOffice 1.x spreadsheet data

Edit Package perl-Spreadsheet-ReadSXC
http://search.cpan.org/dist/Spreadsheet-ReadSXC/

Spreadsheet::ReadSXC extracts data from OpenOffice 1.x spreadsheet files
(.sxc). It exports the function read_sxc() which takes a filename and an
optional reference to a hash of options as arguments and returns a
reference to a hash of references to two-dimensional arrays. The hash keys
correspond to the names of worksheets in the OpenOffice workbook. The
two-dimensional arrays correspond to rows and cells in the respective
spreadsheets. If you don't like this because the order of sheets is not
preserved in a hash, read on. The 'OrderBySheet' option provides an array
of hashes instead.

If you prefer to unpack the .sxc file yourself, you can use the function
read_xml_file() instead and pass the path to content.xml as an argument. Or
you can extract the XML string from content.xml and pass the string to the
function read_xml_string(). Both functions also take a reference to a hash
of options as an optional second argument.

Refresh
Refresh
Source Files
Filename Size Changed
Spreadsheet-ReadSXC-0.24.tar.gz 0000090964 88.8 KB
cpanspec.yml 0000000669 669 Bytes
perl-Spreadsheet-ReadSXC.changes 0000000991 991 Bytes
perl-Spreadsheet-ReadSXC.spec 0000005832 5.7 KB
Revision 5 (latest revision is 18)
Tina Müller's avatar Tina Müller (tinita) accepted request 736426 from Tina Müller's avatar Tina Müller (tinita) (revision 5)
- updated to 0.24
   see /usr/share/doc/packages/perl-Spreadsheet-ReadSXC/Changes
  0.24  2019-10-08
      - Fix parsing the text of cells that only contain "0"
        These were returned as undef, instead of 0 unless the StandardCurrency
        option was used.
      - Fix parsing multiple sheets. If the first cell of the new table was empty,
        the last defined value of the old table was used instead, if the
        real (instead of formatted) values were used.
Comments 0
openSUSE Build Service is sponsored by