Return color index of tab, or undef if not set.
Return true if sheet is hidden
In scalar context, return true if $row is hidden In array context, return an array whose elements are true if the corresponding row is hidden.
In scalar context, return true if $col is hidden In array context, return an array whose elements are true if the corresponding column is hidden.
Spreadsheet::ParseExcel::Worksheet − A class for Worksheets.
See the documentation for Spreadsheet::ParseExcel.
This module is used in conjunction with Spreadsheet::ParseExcel. See the documentation for Spreadsheet::ParseExcel.
The "Spreadsheet::ParseExcel::Worksheet" class encapsulates the properties of an Excel worksheet. It has the following methods:
$worksheet−>get_cell()
$worksheet−>row_range()
$worksheet−>col_range()
$worksheet−>get_name()
$worksheet−>get_h_pagebreaks()
$worksheet−>get_v_pagebreaks()
$worksheet−>get_merged_areas()
$worksheet−>get_row_heights()
$worksheet−>get_col_widths()
$worksheet−>get_default_row_height()
$worksheet−>get_default_col_width()
$worksheet−>get_header()
$worksheet−>get_footer()
$worksheet−>get_margin_left()
$worksheet−>get_margin_right()
$worksheet−>get_margin_top()
$worksheet−>get_margin_bottom()
$worksheet−>get_margin_header()
$worksheet−>get_margin_footer()
$worksheet−>get_paper()
$worksheet−>get_start_page()
$worksheet−>get_print_order()
$worksheet−>get_print_scale()
$worksheet−>get_fit_to_pages()
$worksheet−>is_portrait()
$worksheet−>is_centered_horizontally()
$worksheet−>is_centered_vertically()
$worksheet−>is_print_gridlines()
$worksheet−>is_print_row_col_headers()
$worksheet−>is_print_black_and_white()
$worksheet−>is_print_draft()
$worksheet−>is_print_comments()
Return the "Cell" object at row $row and column $col if it is defined. Otherwise returns undef.
my $cell = $worksheet−>get_cell($row, $col);
Returns a two-element list "($min, $max)" containing the minimum and maximum defined rows in the worksheet. If there is no row defined $max is smaller than $min.
my ( $row_min, $row_max ) = $worksheet−>row_range();
Returns a two-element list "($min, $max)" containing the minimum and maximum of defined columns in the worksheet. If there is no column defined $max is smaller than $min.
my ( $col_min, $col_max ) = $worksheet−>col_range();
The get_name() method returns the name of the worksheet.
my $name = $worksheet−>get_name();
The get_h_pagebreaks() method returns an array ref of row numbers where a horizontal page break occurs.
my $h_pagebreaks = $worksheet−>get_h_pagebreaks();
Returns "undef" if there are no pagebreaks.
The get_v_pagebreaks() method returns an array ref of column numbers where a vertical page break occurs.
my $v_pagebreaks = $worksheet−>get_v_pagebreaks();
Returns "undef" if there are no pagebreaks.
The get_merged_areas() method returns an array ref of cells that are merged.
my $merged_areas = $worksheet−>get_merged_areas();
Each merged area is represented as follows:
[ $start_row, $start_col, $end_row, $end_col]
Returns "undef" if there are no merged areas.
The get_row_heights() method returns an array_ref of row heights in scalar context, and an array in list context.
my $row_heights = $worksheet−>get_row_heights();
Returns "undef" if the property isn’t set.
The get_col_widths() method returns an array_ref of column widths in scalar context, and an array in list context.
my $col_widths = $worksheet−>get_col_widths();
Returns "undef" if the property isn’t set.
The get_default_row_height() method returns the default row height for the worksheet. Generally 12.75.
my $default_row_height = $worksheet−>get_default_row_height();
The get_default_col_width() method returns the default column width for the worksheet. Generally 8.43.
my $default_col_width = $worksheet−>get_default_col_width();
The get_header() method returns the worksheet header string. This string can contain control codes for alignment and font properties. Refer to the Excel on-line help on headers and footers or to the Spreadsheet::WriteExcel documentation for set_header().
my $header = $worksheet−>get_header();
Returns "undef" if the property isn’t set.
The get_footer() method returns the worksheet footer string. This string can contain control codes for alignment and font properties. Refer to the Excel on-line help on headers and footers or to the Spreadsheet::WriteExcel documentation for set_header().
my $footer = $worksheet−>get_footer();
Returns "undef" if the property isn’t set.
The get_margin_left() method returns the left margin of the worksheet in inches.
my $margin_left = $worksheet−>get_margin_left();
Returns "undef" if the property isn’t set.
The get_margin_right() method returns the right margin of the worksheet in inches.
my $margin_right = $worksheet−>get_margin_right();
Returns "undef" if the property isn’t set.
The get_margin_top() method returns the top margin of the worksheet in inches.
my $margin_top = $worksheet−>get_margin_top();
Returns "undef" if the property isn’t set.
The get_margin_bottom() method returns the bottom margin of the worksheet in inches.
my $margin_bottom = $worksheet−>get_margin_bottom();
Returns "undef" if the property isn’t set.
The get_margin_header() method returns the header margin of the worksheet in inches.
my $margin_header = $worksheet−>get_margin_header();
Returns a default value of 0.5 if not set.
The get_margin_footer() method returns the footer margin of the worksheet in inches.
my $margin_footer = $worksheet−>get_margin_footer();
Returns a default value of 0.5 if not set.
The get_paper() method returns the printer paper size.
my $paper = $worksheet−>get_paper();
The value corresponds to the formats shown below:
Index Paper
format Paper size
===== ============ ==========
0 Printer default −
1 Letter 8 1/2 x 11 in
2 Letter Small 8 1/2 x 11 in
3 Tabloid 11 x 17 in
4 Ledger 17 x 11 in
5 Legal 8 1/2 x 14 in
6 Statement 5 1/2 x 8 1/2 in
7 Executive 7 1/4 x 10 1/2 in
8 A3 297 x 420 mm
9 A4 210 x 297 mm
10 A4 Small 210 x 297 mm
11 A5 148 x 210 mm
12 B4 250 x 354 mm
13 B5 182 x 257 mm
14 Folio 8 1/2 x 13 in
15 Quarto 215 x 275 mm
16 − 10x14 in
17 − 11x17 in
18 Note 8 1/2 x 11 in
19 Envelope 9 3 7/8 x 8 7/8
20 Envelope 10 4 1/8 x 9 1/2
21 Envelope 11 4 1/2 x 10 3/8
22 Envelope 12 4 3/4 x 11
23 Envelope 14 5 x 11 1/2
24 C size sheet −
25 D size sheet −
26 E size sheet −
27 Envelope DL 110 x 220 mm
28 Envelope C3 324 x 458 mm
29 Envelope C4 229 x 324 mm
30 Envelope C5 162 x 229 mm
31 Envelope C6 114 x 162 mm
32 Envelope C65 114 x 229 mm
33 Envelope B4 250 x 353 mm
34 Envelope B5 176 x 250 mm
35 Envelope B6 176 x 125 mm
36 Envelope 110 x 230 mm
37 Monarch 3.875 x 7.5 in
38 Envelope 3 5/8 x 6 1/2 in
39 Fanfold 14 7/8 x 11 in
40 German Std Fanfold 8 1/2 x 12 in
41 German Legal Fanfold 8 1/2 x 13 in
256 User defined
The two most common paper sizes are "1 = "US Letter"" and "9 = A4". Returns 9 by default.
The get_start_page() method returns the page number that printing will start from.
my $start_page = $worksheet−>get_start_page();
Returns 0 if the property isn’t set.
The get_print_order() method returns 0 if the worksheet print "page order" is "Down then over" (the default) or 1 if it is "Over then down".
my $print_order = $worksheet−>get_print_order();
The get_print_scale() method returns the workbook scale for printing. The print scale factor can be in the range 10 .. 400.
my $print_scale = $worksheet−>get_print_scale();
Returns 100 by default.
The get_fit_to_pages() method returns the number of pages wide and high that the printed worksheet page will fit to.
my ($pages_wide, $pages_high) = $worksheet−>get_fit_to_pages();
Returns (0, 0) if the property isn’t set.
The is_portrait() method returns true if the worksheet has been set for printing in portrait mode.
my $is_portrait = $worksheet−>is_portrait();
Returns 0 if the worksheet has been set for printing in horizontal mode.
The is_centered_horizontally() method returns true if the worksheet has been centered horizontally for printing.
my $is_centered_horizontally = $worksheet−>is_centered_horizontally();
Returns 0 if the property isn’t set.
The is_centered_vertically() method returns true if the worksheet has been centered vertically for printing.
my $is_centered_vertically = $worksheet−>is_centered_vertically();
Returns 0 if the property isn’t set.
The is_print_gridlines() method returns true if the worksheet print "gridlines" option is turned on.
my $is_print_gridlines = $worksheet−>is_print_gridlines();
Returns 0 if the property isn’t set.
The is_print_row_col_headers() method returns true if the worksheet print "row and column headings" option is turned on.
my $is_print_row_col_headers = $worksheet−>is_print_row_col_headers();
Returns 0 if the property isn’t set.
The is_print_black_and_white() method returns true if the worksheet print "black and white" option is turned on.
my $is_print_black_and_white = $worksheet−>is_print_black_and_white();
Returns 0 if the property isn’t set.
The is_print_draft() method returns true if the worksheet print "draft" option is turned on.
my $is_print_draft = $worksheet−>is_print_draft();
Returns 0 if the property isn’t set.
The is_print_comments() method returns true if the worksheet print "comments" option is turned on.
my $is_print_comments = $worksheet−>is_print_comments();
Returns 0 if the property isn’t set.
Current maintainer 0.60+: Douglas Wilson [email protected]
Maintainer 0.40−0.59: John McNamara [email protected]
Maintainer 0.27−0.33: Gabor Szabo [email protected]
Original author: Kawai Takanori [email protected]
Copyright (c) 2014 Douglas Wilson
Copyright (c) 2009−2013 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.