NAME
Spreadsheet::XLSX::Reader::XMLReader::SharedStrings - A LibXML::Reader sharedStrings base class
SYNOPSIS
#!/usr/bin/env perl
use Data::Dumper;
use MooseX::ShortCut::BuildInstance qw( build_instance );
use Spreadsheet::XLSX::Reader::LibXML::Error;
use Spreadsheet::XLSX::Reader::LibXML::XMLReader::SharedStrings;
my $file_instance = build_instance(
package => 'SharedStringsInstance',
superclasses => ['Spreadsheet::XLSX::Reader::LibXML::XMLReader::SharedStrings'],
file => 'sharedStrings.xml',
error_inst => Spreadsheet::XLSX::Reader::LibXML::Error->new,
);
print Dumper( $file_instance->get_shared_string_position( 3 ) );
print Dumper( $file_instance->get_shared_string_position( 12 ) );
#######################################
# SYNOPSIS Screen Output
# 01: $VAR1 = {
# 02: 'raw_text' => ' '
# 03: };
# 04: $VAR1 = {
# 05: 'raw_text' => 'Superbowl Audibles'
# 06: };
#######################################
DESCRIPTION
This documentation is written to explain ways to use this module when writing your own excel parser or extending this package. To use the general package for excel parsing out of the box please review the documentation for Workbooks , Worksheets , and Cells.
This class is written to extend Spreadsheet::XLSX::Reader::LibXML::XMLReader. It addes to that functionality specifically to read the sharedStrings.xml sub file zipped into an .xlsx file. It does not provide connection to other file types or even the elements from other files that are related to this file. This POD only describes the functionality incrementally provided by this module. For an overview of sharedStrings.xml reading see Spreadsheet::XLSX::Reader::LibXML::SharedStrings
Methods
These are the methods provided by this module.
get_shared_string_position( $positive_int )
Definition: This returns the xml converted to a deep perl data structure from the defined 'si' position.
Accepts: $positive_int ( a positive integer )
Returns: a deep perl data structure built from the xml at 'si' position $positive_int
SUPPORT
TODO
1. Nothing yet
AUTHOR
Jed Lund
jandrew@cpan.org
COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
This software is copyrighted (c) 2014, 2015 by Jed Lund
DEPENDENCIES
SEE ALSO
Spreadsheet::ParseExcel - Excel 2003 and earlier
Spreadsheet::XLSX - 2007+
Spreadsheet::ParseXLSX - 2007+
All lines in this package that use Log::Shiras are commented out