{
    "content": [
        {
            "type": "text",
            "text": "# Spreadsheet::ParseExcel::Cell (perldoc)\n\n## NAME\n\nSpreadsheet::ParseExcel::Cell - A class for Cell data and formatting.\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- **Dates and Time in Excel**\n- **AUTHOR**\n- **COPYRIGHT**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "Spreadsheet::ParseExcel::Cell",
        "section": "",
        "mode": "perldoc",
        "summary": "Spreadsheet::ParseExcel::Cell - A class for Cell data and formatting.",
        "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": 112,
                "subsections": []
            },
            {
                "name": "Dates and Time in Excel",
                "lines": 24,
                "subsections": []
            },
            {
                "name": "AUTHOR",
                "lines": 8,
                "subsections": []
            },
            {
                "name": "COPYRIGHT",
                "lines": 13,
                "subsections": []
            }
        ],
        "sections": {
            "NAME": {
                "content": "Spreadsheet::ParseExcel::Cell - A class for Cell data and formatting.\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 Cell methods are available:\n\n$cell->value()\n$cell->unformatted()\n$cell->getformat()\n$cell->type()\n$cell->encoding()\n$cell->ismerged()\n$cell->getrichtext()\n$cell->gethyperlink()\n\nvalue()\nThe \"value()\" method returns the formatted value of the cell.\n\nmy $value = $cell->value();\n\nFormatted in this sense refers to the numeric format of the cell value. For example a number\nsuch as 40177 might be formatted as 40,117, 40117.000 or even as the date 2009/12/30.\n\nIf the cell doesn't contain a numeric format then the formatted and unformatted cell values are\nthe same, see the \"unformatted()\" method below.\n\nFor a defined $cell the \"value()\" method will always return a value.\n\nIn the case of a cell with formatting but no numeric or string contents the method will return\nthe empty string ''.\n\nunformatted()\nThe \"unformatted()\" method returns the unformatted value of the cell.\n\nmy $unformatted = $cell->unformatted();\n\nReturns the cell value without a numeric format. See the \"value()\" method above.\n\ngetformat()\nThe \"getformat()\" method returns the Spreadsheet::ParseExcel::Format object for the cell.\n\nmy $format = $cell->getformat();\n\nIf a user defined format hasn't been applied to the cell then the default cell format is\nreturned.\n\ntype()\nThe \"type()\" method returns the type of cell such as Text, Numeric or Date. If the type was\ndetected as Numeric, and the Cell Format matches \"m{^[dmy][-\\\\/dmy]*$}i\", it will be treated as\na Date type.\n\nmy $type = $cell->type();\n\nSee also \"Dates and Time in Excel\".\n\nencoding()\nThe \"encoding()\" method returns the character encoding of the cell.\n\nmy $encoding = $cell->encoding();\n\nThis method is only of interest to developers. In general Spreadsheet::ParseExcel will return\nall character strings in UTF-8 regardless of the encoding used by Excel.\n\nThe \"encoding()\" method returns one of the following values:\n\n*   0: Unknown format. This shouldn't happen. In the default case the format should be 1.\n\n*   1: 8bit ASCII or single byte UTF-16. This indicates that the characters are encoded in a\nsingle byte. In Excel 95 and earlier This usually meant ASCII or an international variant.\nIn Excel 97 it refers to a compressed UTF-16 character string where all of the high order\nbytes are 0 and are omitted to save space.\n\n*   2: UTF-16BE.\n\n*   3: Native encoding. In Excel 95 and earlier this encoding was used to represent multi-byte\ncharacter encodings such as SJIS.\n\nismerged()\nThe \"ismerged()\" method returns true if the cell is merged.\n\nmy $ismerged = $cell->ismerged();\n\nReturns \"undef\" if the property isn't set.\n\ngetrichtext()\nThe \"getrichtext()\" method returns an array ref of font information about each string block in\na \"rich\", i.e. multi-format, string.\n\nmy $richtext = $cell->getrichtext();\n\nThe return value is an arrayref of arrayrefs in the form:\n\n[\n[ $startposition, $fontobject ],\n...,\n]\n\nReturns undef if the property isn't set.\n\ngethyperlink()\nIf a cell contains a hyperlink, the \"gethyperlink()\" method returns an array ref of information\nabout it.\n\nA cell can contain at most one hyperlink. If it does, it contains no other value.\n\nOtherwise, it returns undef;\n\nThe array contains:\n\n*   0: Description (what's displayed); undef if not present\n\n*   1: Link, converted to an appropriate URL - Note: Relative links are based on the input file.\n%REL% is used if the input file is unknown (e.g. a file handle or scalar)\n\n*   2: Target - target frame (or undef if none)\n",
                "subsections": []
            },
            "Dates and Time in Excel": {
                "content": "Dates and times in Excel are represented by real numbers, for example \"Jan 1 2001 12:30 PM\" is\nrepresented by the number 36892.521.\n\nThe integer part of the number stores the number of days since the epoch and the fractional part\nstores the percentage of the day.\n\nA date or time in Excel is just like any other number. The way in which it is displayed is\ncontrolled by the number format:\n\nNumber format               $cell->value()            $cell->unformatted()\n=============               ==============            ==============\n'dd/mm/yy'                  '28/02/08'                39506.5\n'mm/dd/yy'                  '02/28/08'                39506.5\n'd-m-yyyy'                  '28-2-2008'               39506.5\n'dd/mm/yy hh:mm'            '28/02/08 12:00'          39506.5\n'd mmm yyyy'                '28 Feb 2008'             39506.5\n'mmm d yyyy hh:mm AM/PM'    'Feb 28 2008 12:00 PM'    39506.5\n\nThe Spreadsheet::ParseExcel::Utility module contains a function called \"ExcelLocaltime\" which\nwill convert between an unformatted Excel date/time number and a \"localtime()\" like array.\n\nFor date conversions using the CPAN \"DateTime\" framework see DateTime::Format::Excel\nhttp://search.cpan.org/search?dist=DateTime-Format-Excel\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": []
            }
        }
    }
}