Package : perl-Spreadsheet-ReadSXC > RPM : perl-Spreadsheet-ReadSXC-0.200.0-8.mga7.src.rpm

Basic items

Name perl-Spreadsheet-ReadSXC
Version 0.200.0
Release 8.mga7
URL http://search.cpan.org/dist/Spreadsheet-ReadSXC
Group Development/Perl
Summary Extract OpenOffice 1.x spreadsheet data
Size 16KB
Arch noarch
License GPL+ or Artistic

Description

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.

Spreadsheet::ReadSXC requires XML::Parser to parse the XML contained in
.sxc files. Only the contents of text:p elements are returned, not the
actual values of table:value attributes. For example, a cell might have a
table:value-type attribute of "currency", a table:value attribute of
"-1500.99" and a table:currency attribute of "USD". The text:p element
would contain "-$1,500.99". This is the string which is returned by the
read_sxc() function, not the value of -1500.99.

Media information

Distribution release Mageia 7
Media name core-release
Media arch i586

Advanced items

Source RPM NOT IN DATABASE ?!
Build time 2018-09-19 13:01:13
Changelog View in Sophie
Files View in Sophie
Dependencies View in Sophie