1Spreadsheet::XLSX::Fmt2U0s0e7r(3C)ontributed Perl DocumeSnptraetaidosnheet::XLSX::Fmt2007(3)
2
3
4
6 $cell = $myworkbook->worksheet->{Cells}[$row][$col]
7 my $type = $cell->{Type}; # Date, Text, or Numeric
8 my $disp_value = $cell->Value; # displayed (formatted) value set in XLSX by $myFmt2007->ValFmt($cell, $workbook)
9 my $fund_value = $cell->{Val}; # fundemental (underlying) value
10 my $formatter;
11 if ($myworkbook->excel07) {
12 $formatter=Spreadsheet::XLSX::Fmt2007->new();
13 } else {
14 $formatter=Spreadsheet::ParseExcel::FmtDefault->new();
15 }
16 my $format_string = $formatter->FmtString($cell,$self->workbook);
17
18
19
20perl v5.38.0 2023-07-21 Spreadsheet::XLSX::Fmt2007(3)