Spreadsheet::XLSX::Fmt2007 - A class for Cell formats.
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);
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.
See the documentation for Spreadsheet::XLSX.
To install Spreadsheet::XLSX, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Spreadsheet::XLSX
CPAN shell
perl -MCPAN -e shell install Spreadsheet::XLSX
For more information on module installation, please visit the detailed CPAN module installation guide.