John McNamara > Spreadsheet-ParseExcel-0.59 > Spreadsheet::ParseExcel::Workbook

Download:
Spreadsheet-ParseExcel-0.59.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  7
Open  14
View/Report Bugs
Module Version: 0.59   Source   Latest Release: Spreadsheet-ParseExcel-0.65

NAME ^

Spreadsheet::ParseExcel::Workbook - A class for Workbooks.

SYNOPSIS ^

See the documentation for Spreadsheet::ParseExcel.

DESCRIPTION ^

This module is used in conjunction with Spreadsheet::ParseExcel. See the documentation for Spreadsheet::ParseExcel.

Methods ^

The following Workbook methods are available:

    $workbook->worksheets()
    $workbook->worksheet()
    $workbook->worksheet_count()
    $workbook->get_filename()
    $workbook->get_print_areas()
    $workbook->get_print_titles()
    $workbook->using_1904_date()

worksheets()

The worksheets() method returns an array of Worksheet objects. This was most commonly used to iterate over the worksheets in a workbook:

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

worksheet()

The worksheet() method returns a single Worksheet object using either its name or index:

    $worksheet = $workbook->worksheet('Sheet1');
    $worksheet = $workbook->worksheet(0);

Returns undef if the sheet name or index doesn't exist.

worksheet_count()

The worksheet_count() method returns the number of Woksheet objects in the Workbook.

    my $worksheet_count = $workbook->worksheet_count();

get_filename()

The get_filename() method returns the name of the Excel file of undef if the data was read from a filehandle rather than a file.

    my $filename = $workbook->get_filename();

get_print_areas()

The get_print_areas() method returns an array ref of print areas.

    my $print_areas = $workbook->get_print_areas();

Each print area is as follows:

    [ $start_row, $start_col, $end_row, $end_col ]

Returns undef if there are no print areas.

get_print_titles()

The get_print_titles() method returns an array ref of print title hash refs.

    my $print_titles = $workbook->get_print_titles();

Each print title array ref is as follows:

    {
        Row    => [ $start_row, $end_row ],
        Column => [ $start_col, $end_col ],
    }

Returns undef if there are no print titles.

using_1904_date()

The using_1904_date() method returns true if the Excel file is using the 1904 date epoch instead of the 1900 epoch.

    my $using_1904_date = $workbook->using_1904_date();

 The Windows version of Excel generally uses the 1900 epoch while the Mac version of Excel generally uses the 1904 epoch.

Returns 0 if the 1900 epoch is in use.

AUTHOR ^

Maintainer 0.40+: John McNamara jmcnamara@cpan.org

Maintainer 0.27-0.33: Gabor Szabo szabgab@cpan.org

Original author: Kawai Takanori kwitknr@cpan.org

COPYRIGHT ^

Copyright (c) 2009-2010 John McNamara

Copyright (c) 2006-2008 Gabor Szabo

Copyright (c) 2000-2006 Kawai Takanori

All rights reserved.

You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.

syntax highlighting: