NAME

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.