Linux Certif

Toute la documentation sur la certification Linux LPI

Spreadsheet::XLSX::Fmt2007.3pm

NAME

Spreadsheet::XLSX::Fmt2007 - Formatting module for Spreadsheet::XLSX

SYNOPSIS

                 $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);