Scroll to navigation

Spreadsheet::XLSX(3) User Contributed Perl Documentation Spreadsheet::XLSX(3)

NAME

Spreadsheet::XLSX - Perl extension for reading MS Excel 2007 files.

SYNOPSIS

    use Text::Iconv;
    my $converter = Text::Iconv->new("utf-8", "windows-1251");
    
    # Text::Iconv is not really required.
    # This can be any object with the convert method. Or nothing.
    
    use Spreadsheet::XLSX;
    
    my $excel = Spreadsheet::XLSX->new('test.xlsx', $converter);
    
    foreach my $sheet (@{$excel->{Worksheet}}) {
    
        printf("Sheet: %s\n", $sheet->{Name});
        
        $sheet->{MaxRow} ||= $sheet->{MinRow};
        
        foreach my $row ($sheet->{MinRow} .. $sheet->{MaxRow}) {
             
            $sheet->{MaxCol} ||= $sheet->{MinCol};
            
            foreach my $col ($sheet->{MinCol} ..  $sheet->{MaxCol}) {
            
                my $cell = $sheet->{Cells}[$row][$col];
        
                if ($cell) {
                    printf("( %s , %s ) => %s\n", $row, $col, $cell->{Val});
                }
        
            }
        
        }
    
    }

DESCRIPTION

ZIP input is limited to 10,000 entries, 64 MiB per uncompressed member, and 256 MiB of total declared uncompressed data, including unused members. Members used by the parser are decompressed incrementally and their actual sizes are checked against the limits and ZIP metadata. Exceeding a limit or encountering inconsistent sizes raises an exception.

Applications needing different limits can scope them to a parsing operation:

    local $Spreadsheet::XLSX::MAX_MEMBER_SIZE = 128 * 1024 * 1024;
    local $Spreadsheet::XLSX::MAX_TOTAL_SIZE = 512 * 1024 * 1024;
    local $Spreadsheet::XLSX::MAX_MEMBERS = 20000;
    my $excel = Spreadsheet::XLSX->new($filename);

These limits bound uncompressed input, not the total memory used by parsed cells and XML processing.

This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format. It supports styles and many of Excel's quirks, but not all. It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet, and Cell.

SEE ALSO

This module (Spreadsheet::XLSX) has some serious issues with the way it uses regexs for parsing the XML. I would strongly encourage switching to Spreadsheet::ParseXLSX which takes a more reliable approach.
for xlscat likewise functionality (Excel only)
for an alternative set of cell2cr() / cr2cell() pair
offers a Pure Perl implementation of a spreadsheet engine. Users that want this format to be supported in Spreadsheet::Read are hereby motivated to offer patches. It's not high on my todo-list.
<https://metacpan.org/release/KEN/xls2csv-1.07> offers an alternative for my "xlscat -c", in the xls2csv tool, but this tool focusses on character encoding transparency, and requires some other modules.
read the data from a spreadsheet (interface module)

AUTHOR

Dmitry Ovsyanko, <do@eludia.ru>, http://eludia.ru/wiki/

Patches by:

        Steve Simms
        Joerg Meltzer
        Loreyna Yeung   
        Rob Polocz
        Gregor Herrmann
        H.Merijn Brand
        endacoe
        Pat Mariani
        Sergey Pushkin

ACKNOWLEDGEMENTS

        Thanks to TrackVia Inc. (http://www.trackvia.com) for paying for Rob Polocz working time.

COPYRIGHT AND LICENSE

Copyright (C) 2008 by Dmitry Ovsyanko

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.

2026-10-30 perl v5.44.0