Spreadsheet::XLSX::Fmt2007 - A class for Cell formats.
NAME SYNOPSIS DESCRIPTION AUTHOR COPYRIGHTNAME
Spreadsheet::XLSX::Fmt2007 − A class for Cell formats.
SYNOPSIS
See the documentation of Spreadsheet::XLSX.
my $cell =
$myworkbook−>worksheet−>{Cells}[$row][$col]
my $type = $cell−>{Type}; # Date, Text, or Numeric
my $disp_value = $cell−>Value; # displayed
(formatted) value set in XLSX by
$myFmt2007−>ValFmt($cell, $workbook)
my $fund_value = $cell−>{Val}; # fundemental
(underlying) value
my $formatter;
if( $myworkbook−>excel07 ) {
$formatter = Spreadsheet::XLSX::Fmt2007−>new();
} else {
$formatter =
Spreadsheet::ParseExcel::FmtDefault−>new();
}
my $format_string = $formatter−>FmtString($cell,
$self−>workbook);
DESCRIPTION
This module is used in conjunction with Spreadsheet::XLSX. See the documentation for Spreadsheet::XLSX.
This code is adapted for Excel 2007 from Spreadsheet::ParseExcel::FmtDefault by Kawai, Takanori (Hippo2000) 2001−02−02. This Program is ALPHA version.
AUTHOR
See the documentation for Spreadsheet::XLSX.
COPYRIGHT
See the documentation for Spreadsheet::XLSX.