1Spreadsheet::ParseExcelU:s:eWrorCkobnotorki(b3u)ted PerlSpDroecaudmsehneteatt:i:oPnarseExcel::Workbook(3)
2
3
4
5   get_active_sheet()
6       Return the number of the active (open) worksheet (at the time the
7       workbook was saved.  May return undef.
8

NAME

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

SYNOPSIS

13       See the documentation for Spreadsheet::ParseExcel.
14

DESCRIPTION

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

Methods

20       The following Workbook methods are available:
21
22           $workbook->worksheets()
23           $workbook->worksheet()
24           $workbook->worksheet_count()
25           $workbook->get_filename()
26           $workbook->get_print_areas()
27           $workbook->get_print_titles()
28           $workbook->using_1904_date()
29
30   worksheets()
31       The "worksheets()" method returns an array of Worksheet objects. This
32       was most commonly used to iterate over the worksheets in a workbook:
33
34           for my $worksheet ( $workbook->worksheets() ) {
35               ...
36           }
37
38   worksheet()
39       The "worksheet()" method returns a single "Worksheet" object using
40       either its name or index:
41
42           $worksheet = $workbook->worksheet('Sheet1');
43           $worksheet = $workbook->worksheet(0);
44
45       Returns "undef" if the sheet name or index doesn't exist.
46
47   worksheet_count()
48       The "worksheet_count()" method returns the number of Woksheet objects
49       in the Workbook.
50
51           my $worksheet_count = $workbook->worksheet_count();
52
53   get_filename()
54       The "get_filename()" method returns the name of the Excel file of
55       "undef" if the data was read from a filehandle rather than a file.
56
57           my $filename = $workbook->get_filename();
58
59   get_print_areas()
60       The "get_print_areas()" method returns an array ref of print areas.
61
62           my $print_areas = $workbook->get_print_areas();
63
64       Each print area is as follows:
65
66           [ $start_row, $start_col, $end_row, $end_col ]
67
68       Returns undef if there are no print areas.
69
70   get_print_titles()
71       The "get_print_titles()" method returns an array ref of print title
72       hash refs.
73
74           my $print_titles = $workbook->get_print_titles();
75
76       Each print title array ref is as follows:
77
78           {
79               Row    => [ $start_row, $end_row ],
80               Column => [ $start_col, $end_col ],
81           }
82
83       Returns undef if there are no print titles.
84
85   using_1904_date()
86       The "using_1904_date()" method returns true if the Excel file is using
87       the 1904 date epoch instead of the 1900 epoch.
88
89           my $using_1904_date = $workbook->using_1904_date();
90
91        The Windows version of Excel generally uses the 1900 epoch while the Mac version of Excel generally uses the 1904 epoch.
92
93       Returns 0 if the 1900 epoch is in use.
94

AUTHOR

96       Current maintainer 0.60+: Douglas Wilson dougw@cpan.org
97
98       Maintainer 0.40-0.59: John McNamara jmcnamara@cpan.org
99
100       Maintainer 0.27-0.33: Gabor Szabo szabgab@cpan.org
101
102       Original author: Kawai Takanori kwitknr@cpan.org
103

105       Copyright (c) 2014 Douglas Wilson
106
107       Copyright (c) 2009-2013 John McNamara
108
109       Copyright (c) 2006-2008 Gabor Szabo
110
111       Copyright (c) 2000-2006 Kawai Takanori
112
113       All rights reserved.
114
115       You may distribute under the terms of either the GNU General Public
116       License or the Artistic License, as specified in the Perl README file.
117
118
119
120perl v5.30.1                      2020-01-3S0preadsheet::ParseExcel::Workbook(3)
Impressum