Extract OpenOffice 1.x spreadsheet data
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.
- Sources inherited from project devel:languages:perl
- Devel package for openSUSE:Factory
- Links to openSUSE:Factory / perl-Spreadsheet-ReadSXC
- Has a link diff
- Download package
-
Checkout Package
osc -A https://api.opensuse.org checkout home:Tomcat42/perl-Spreadsheet-ReadSXC && cd $_
- Create Badge
Source Files
Filename | Size | Changed |
---|---|---|
Spreadsheet-ReadSXC-0.24.tar.gz | 0000090964 88.8 KB | |
_link | 0000000159 159 Bytes | |
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)
- 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