The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
Spreadsheet-Reader-ExcelXML-v0.16.8
River stage zero No dependents
1 ++
/ Spreadsheet::Reader::ExcelXML::XMLReader::WorkbookXML

NAME

Spreadsheet::Reader::ExcelXML::XMLReader::WorkbookXML - Workbook flat XML file test

SYNOPSIS

        #!/usr/bin/env perl
        use MooseX::ShortCut::BuildInstance qw( build_instance );
        use Spreadsheet::Reader::ExcelXML::XMLReader;
        use     Spreadsheet::Reader::ExcelXML::XMLReader::WorkbookXML;
        use Spreadsheet::Reader::ExcelXML::WorkbookFileInterface;
        my      $test_file = '../../../../t/test_files/TestBook.xml';
        my      $test_instance =  build_instance(
                        package => 'WorkbookFileInterface',
                        superclasses => ['Spreadsheet::Reader::ExcelXML::XMLReader'],
                        add_roles_in_sequence =>[
                                'Spreadsheet::Reader::ExcelXML::XMLReader::WorkbookXML',
                                'Spreadsheet::Reader::ExcelXML::WorkbookFileInterface',
                        ],
                        file => $test_file,
                );
        my $sub_file = $test_instance->extract_file( 'Styles' );
        print $sub_file->getline;

        ###########################
        # SYNOPSIS Screen Output
        # 01: <?xml version="1.0"?><Styles><Style ss:ID="Default"/ ~~ / ss:ID="s22"><Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="14" ss:Color="#000000"
        ###########################

DESCRIPTION

This documentation is written to explain ways to use this module when writing your own excel parser. To use the general package for excel parsing out of the box please review the documentation for Workbooks, Worksheets, and Cells

This is the XML based file adaptor for reading the base xml flat file and determining if it has the expected attribute in the mso-application header indicating it is a SpreadsheetML format file. ( progid="Excel.Sheet" ) When combined with the generic XML reader and the WorkbookFileInterface interface it makes a complete base xml flat file reader.

Required Methods

These are the methods required by the role. A link to the default implementation of these methods is provided.

"progid" in Spreadsheet::Reader::ExcelXML::XMLReader

"has_progid" in Spreadsheet::Reader::ExcelXML::XMLReader

"good_load( $state )" in Spreadsheet::Reader::ExcelXML::XMLReader

Methods

These are the methods provided by this role (only).

load_unique_bits

    Definition: This role is meant to run on top of Spreadsheet::Reader::ExcelXML::XMLReader. When it does the reader will call this function as available when it first starts the file. This particular version only tests for the correct attribute (progid="Excel.Sheet") in the 'mso-application' header.

    Accepts: nothing

    Returns: nothing

SUPPORT

TODO

    1. Nothing currently

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) 2016 by Jed Lund

DEPENDENCIES

SEE ALSO