|o||0: Unknown format. This shouldnt happen. In the default case the format should be 1.|
|o||1: 8bit ASCII or single byte UTF-16. This indicates that the characters are encoded in a single byte. In Excel 95 and earlier This usually meant ASCII or an international variant. In Excel 97 it refers to a compressed UTF-16 character string where all of the high order bytes are 0 and are omitted to save space.|
|o||3: Native encoding. In Excel 95 and earlier this encoding was used to represent multi-byte character encodings such as SJIS.|
my $is_merged = $cell->is_merged();
my $rich_text = $cell->get_rich_text();
The return value is an arrayref of arrayrefs in the form:
[ $start_position, $font_object ],
A cell can contain at most one hyperlink. If it does, it contains no other value.
Otherwise, it returns undef;
The array contains:
|o||0: Description (whats displayed); undef if not present|
|o||1: Link, converted to an appropriate URL - Note: Relative links are based on the input file. %REL% is used if the input file is unknown (e.g. a file handle or scalar)|
|o||2: Target - target frame (or undef if none)|
Dates and times in Excel are represented by real numbers, for example Jan 1 2001 12:30 PM is represented by the number 36892.521.
A date or time in Excel is just like any other number. The way in which it is displayed is controlled by the number format:
Number format $cell->value() $cell->unformatted() ============= ============== ============== dd/mm/yy 28/02/08 39506.5 mm/dd/yy 02/28/08 39506.5 d-m-yyyy 28-2-2008 39506.5 dd/mm/yy hh:mm 28/02/08 12:00 39506.5 d mmm yyyy 28 Feb 2008 39506.5 mmm d yyyy hh:mm AM/PM Feb 28 2008 12:00 PM 39506.5
The Spreadsheet::ParseExcel::Utility module contains a function called ExcelLocaltime which will convert between an unformatted Excel date/time number and a localtime() like array.
For date conversions using the CPAN DateTime framework see DateTime::Format::Excel http://search.cpan.org/search?dist=DateTime-Format-Excel
Current maintainer 0.60+: Douglas Wilson firstname.lastname@example.org
Maintainer 0.40-0.59: John McNamara email@example.com
Maintainer 0.27-0.33: Gabor Szabo firstname.lastname@example.org
Original author: Kawai Takanori email@example.com
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.
|perl v5.20.3||SPREADSHEET::PARSEEXCEL::CELL (3)||2014-03-18|