{
    "mode": "perldoc",
    "parameter": "Spreadsheet::ParseExcel::Workbook",
    "section": "",
    "url": "https://www.chedong.com/phpMan.php/perldoc/Spreadsheet%3A%3AParseExcel%3A%3AWorkbook/json",
    "generated": "2026-06-09T18:25:42Z",
    "synopsis": "See the documentation for Spreadsheet::ParseExcel.",
    "sections": {
        "NAME": {
            "content": "Spreadsheet::ParseExcel::Workbook - A class for Workbooks.\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "See the documentation for Spreadsheet::ParseExcel.\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "This module is used in conjunction with Spreadsheet::ParseExcel. See the documentation for\nSpreadsheet::ParseExcel.\n",
            "subsections": []
        },
        "Methods": {
            "content": "The following Workbook methods are available:\n\n$workbook->worksheets()\n$workbook->worksheet()\n$workbook->worksheetcount()\n$workbook->getfilename()\n$workbook->getprintareas()\n$workbook->getprinttitles()\n$workbook->using1904date()\n\nworksheets()\nThe \"worksheets()\" method returns an array of Worksheet objects. This was most commonly used to\niterate over the worksheets in a workbook:\n\nfor my $worksheet ( $workbook->worksheets() ) {\n...\n}\n\nworksheet()\nThe \"worksheet()\" method returns a single \"Worksheet\" object using either its name or index:\n\n$worksheet = $workbook->worksheet('Sheet1');\n$worksheet = $workbook->worksheet(0);\n\nReturns \"undef\" if the sheet name or index doesn't exist.\n\nworksheetcount()\nThe \"worksheetcount()\" method returns the number of Woksheet objects in the Workbook.\n\nmy $worksheetcount = $workbook->worksheetcount();\n\ngetfilename()\nThe \"getfilename()\" method returns the name of the Excel file of \"undef\" if the data was read\nfrom a filehandle rather than a file.\n\nmy $filename = $workbook->getfilename();\n\ngetprintareas()\nThe \"getprintareas()\" method returns an array ref of print areas.\n\nmy $printareas = $workbook->getprintareas();\n\nEach print area is as follows:\n\n[ $startrow, $startcol, $endrow, $endcol ]\n\nReturns undef if there are no print areas.\n\ngetprinttitles()\nThe \"getprinttitles()\" method returns an array ref of print title hash refs.\n\nmy $printtitles = $workbook->getprinttitles();\n\nEach print title array ref is as follows:\n\n{\nRow    => [ $startrow, $endrow ],\nColumn => [ $startcol, $endcol ],\n}\n\nReturns undef if there are no print titles.\n\nusing1904date()\nThe \"using1904date()\" method returns true if the Excel file is using the 1904 date epoch\ninstead of the 1900 epoch.\n\nmy $using1904date = $workbook->using1904date();\n\nThe Windows version of Excel generally uses the 1900 epoch while the Mac version of Excel generally uses the 1904 epoch.\n\nReturns 0 if the 1900 epoch is in use.\n",
            "subsections": []
        },
        "AUTHOR": {
            "content": "Current maintainer 0.60+: Douglas Wilson dougw@cpan.org\n\nMaintainer 0.40-0.59: John McNamara jmcnamara@cpan.org\n\nMaintainer 0.27-0.33: Gabor Szabo szabgab@cpan.org\n\nOriginal author: Kawai Takanori kwitknr@cpan.org\n",
            "subsections": []
        },
        "COPYRIGHT": {
            "content": "Copyright (c) 2014 Douglas Wilson\n\nCopyright (c) 2009-2013 John McNamara\n\nCopyright (c) 2006-2008 Gabor Szabo\n\nCopyright (c) 2000-2006 Kawai Takanori\n\nAll rights reserved.\n\nYou may distribute under the terms of either the GNU General Public License or the Artistic\nLicense, as specified in the Perl README file.\n",
            "subsections": []
        }
    },
    "summary": "Spreadsheet::ParseExcel::Workbook - A class for Workbooks.",
    "flags": [],
    "examples": [],
    "see_also": []
}