| Name : perl-Spreadsheet-ReadSXC
| |
| Version : 0.200.0
| Vendor : Mandriva
|
| Release : 1mdv2010.1
| Date : 2010-03-16 18:14:45
|
| Group : Development/Perl
| Source RPM : perl-Spreadsheet-ReadSXC-0.200.0-1mdv2010.1.src.rpm
|
| Size : 0.02 MB
| |
| Packager : Jérôme Quelin < jquelin_mandriva_org>
| |
| Summary : Extract OpenOffice 1.x spreadsheet data
|
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.
|
RPM found in directory: /vol/rzm6/linux-mandriva/official/2010.1/i586/media/contrib/release |
