Spreadsheet::XLSX::Utility2007 0.13

Spreadsheet::XLSX::Utility2007 is an utility function for Spreadsheet::XLSX.

SYNOPSIS

 use strict;
 #Declare
 use Spreadsheet::XLSX::Utility qw(ExcelFmt ExcelLocaltime LocaltimeExcel);
 
 #Convert localtime ->Excel Time
 my $iBirth = LocaltimeExcel(11, 10, 12, 23, 2, 64);
 # = 1964-3-23 12:10:11
 print $iBirth, "
"; # 23459.5070717593
 
 #Convert Excel Time -> localtime
 my @aBirth = ExcelLocaltime($iBirth, undef);
 print join(":", @aBirth), "
"; # 11:10:12:23:2:64:1:0
 
 #Formatting
 print ExcelFmt('yyyy-mm-dd', $iBirth), "
"; #1964-3-23
 print ExcelFmt('m-d-yy', $iBirth), "
"; # 3-23-64
 print ExcelFmt('#,##0', $iBirth), "
"; # 23,460
 print ExcelFmt('#,##0.00', $iBirth), "
"; # 23,459.51
 print ExcelFmt('"My Birthday is (m/d):" m/d', $iBirth), "
";
 # My Birthday is (m/d): 3/23

Spreadsheet::XLSX::Utility exports utility functions concerned with Excel format setting.

ExcelFmt is used by Spreadsheet::XLSX::Fmt2007.pm which is used by Spreadsheet::XLSX.


Product's homepage

Requirements:

· Perl