Formatting module for spreadsheet::xlsx
$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);