{
    "content": [
        {
            "type": "text",
            "text": "# Spreadsheet::ParseExcel::Workbook (perldoc)\n\n## NAME\n\nSpreadsheet::ParseExcel::Workbook - A class for Workbooks.\n\n## SYNOPSIS\n\nSee the documentation for Spreadsheet::ParseExcel.\n\n## DESCRIPTION\n\nThis module is used in conjunction with Spreadsheet::ParseExcel. See the documentation for\nSpreadsheet::ParseExcel.\n\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **Methods**\n- **AUTHOR**\n- **COPYRIGHT**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "Spreadsheet::ParseExcel::Workbook",
        "section": "",
        "mode": "perldoc",
        "summary": "Spreadsheet::ParseExcel::Workbook - A class for Workbooks.",
        "synopsis": "See the documentation for Spreadsheet::ParseExcel.",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "flags": [],
        "examples": [],
        "see_also": [],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 3,
                "subsections": []
            },
            {
                "name": "Methods",
                "lines": 72,
                "subsections": []
            },
            {
                "name": "AUTHOR",
                "lines": 8,
                "subsections": []
            },
            {
                "name": "COPYRIGHT",
                "lines": 13,
                "subsections": []
            }
        ],
        "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": []
            }
        }
    }
}