Spreads...Fmt2007(3)

💖 NAME 💖

okay so bestie, this is the Spreads...Fmt2007(3) page, and we’re hanging out in the User Contributed Perl Documentation section. It’s all about Spreadsheet::XLSX::Fmt2007 — literally A class for Cell formats. slay. ✨

✨ SYNOPSIS ✨

First things first: See the documentation of Spreadsheet::XLSX.

Then the vibe is this little snippet, reproduced exactly:

    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. no cap, that’s the whole friend group. 🫶

This code is adapted for Excel 2007 from Spreadsheet::ParseExcel::FmtDefault by Kawai, Takanori (Hippo2000) 2001-02-02. iconic lineage, honestly. 🌈

⚠️ This Program is ALPHA version. So yeah, keep that in mind, bestie — it’s giving experimental main character energy. 💀

🫶 AUTHOR 🫶

See the documentation for Spreadsheet::XLSX. That’s the author tea, fr fr. ☕

🎀 COPYRIGHT 🎀

See the documentation for Spreadsheet::XLSX. Same energy, same place, periodt. 💅

---

mwah 💋 this page is brought to you by perl v5.42.0, dated 2024-03-22 — bye bestie, go format some Cells! 🦋