Spreadsheet::XLSX::Fmt2007 - Spreadsheet::XLSX::Fmt2007 documentation


Spreadsheet-XLSX documentation  | view source Contained in the Spreadsheet-XLSX distribution.

Index


SYNOPSIS

Top

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





Spreadsheet-XLSX documentation  | view source Contained in the Spreadsheet-XLSX distribution.