Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
Name: perl-Spreadsheet-ReadSXC | Distribution: OpenMandriva Lx |
Version: 0.200.0 | Vendor: OpenMandriva |
Release: 5 | Build date: Mon Nov 2 17:35:42 2020 |
Group: Development/Perl | Build host: rhel.openmandriva.org |
Size: 24495 | Source RPM: perl-Spreadsheet-ReadSXC-0.200.0-5.src.rpm |
Packager: bero <bero@lindev.ch> | |
Url: http://search.cpan.org/dist/Spreadsheet-ReadSXC | |
Summary: 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. 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.
GPL+ or Artistic
* Sun Apr 17 2011 Funda Wang <fwang@mandriva.org> 0.200.0-2mdv2011.0 + Revision: 654295 - rebuild for updated spec-helper * Tue Mar 16 2010 Jérôme Quelin <jquelin@mandriva.org> 0.200.0-1mdv2011.0 + Revision: 521751 - import perl-Spreadsheet-ReadSXC * Tue Mar 16 2010 cpan2dist 0.20-1mdv - initial mdv release, generated with cpan2dist
/usr/share/doc/perl-Spreadsheet-ReadSXC /usr/share/doc/perl-Spreadsheet-ReadSXC/Changes /usr/share/doc/perl-Spreadsheet-ReadSXC/META.yml /usr/share/doc/perl-Spreadsheet-ReadSXC/README /usr/share/man/man3/Spreadsheet::ReadSXC.3pm.zst /usr/share/perl5/vendor_perl/Spreadsheet /usr/share/perl5/vendor_perl/Spreadsheet/ReadSXC.pm
Generated by rpm2html 1.8.1
Fabrice Bellet, Wed Nov 13 23:03:53 2024