excel-reader-xlsx

excel-reader-xlsx copied to clipboard

Note:

This project is effectively abandoned. I don't have the required time to finish it off and get it to CPAN quality.

It is functional and if it meets your requirements then please use it but it is unlikely that it will ever be extended.

As an alternative have a look at the Spreadsheet::ParseXLSX module which is on CPAN.

http://search.cpan.org/~doy/Spreadsheet-ParseXLSX/lib/Spreadsheet/ParseXLSX.pm

NAME

Excel::Reader::XLSX - Read data from an Excel 2007+/XLSX format file.

DESCRIPTION

Excel::Reader::XLSX is a fast and lightweight parser for Excel 2007+
XLSX files.

The XLSX format is the Office Open XML (OOXML) format used by Excel 2007
and later.

SYNOPSIS

A simple Excel XLSX file reader based on Excel::Reader::XLSX:

use strict;
use warnings;
use Excel::Reader::XLSX;

my $reader   = Excel::Reader::XLSX->new();
my $workbook = $reader->read_file( 'Book1.xlsx' );

if ( !defined $workbook ) {
    die $reader->error(), "\n";
}

for my $worksheet ( $workbook->worksheets() ) {

    my $sheetname = $worksheet->name();

    print "Sheet = $sheetname\n";

    while ( my $row = $worksheet->next_row() ) {

        while ( my $cell = $row->next_cell() ) {

            my $row   = $cell->row();
            my $col   = $cell->col();
            my $value = $cell->value();

            print "  Cell ($row, $col) = $value\n";
        }
    }
}

INSTALLATION

Use the standard Unix style installation. Unzip and untar the module:

    tar -zxvf Excel-Reader-XLSX-0.xx.tar.gz

The module can be installed using the standard Perl procedure:

    perl Makefile.PL
    make
    make test
    make install    # As sudo/root

AUTHOR

John McNamara ([email protected])