Spreadsheet::XLSX::Utility2007

Utility function for Spreadsheet::XLSX
Download

Spreadsheet::XLSX::Utility2007 Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Perl Artistic License
  • Price:
  • FREE
  • Publisher Name:
  • Dmitry Ovsyanko
  • Publisher web site:
  • http://search.cpan.org/~dmow/

Spreadsheet::XLSX::Utility2007 Tags


Spreadsheet::XLSX::Utility2007 Description

Utility function for Spreadsheet::XLSX 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/23Spreadsheet::XLSX::Utility exports utility functions concerned with Excel format setting.ExcelFmt is used by Spreadsheet::XLSX::Fmt2007.pm which is used by Spreadsheet::XLSX. Requirements: · Perl


Spreadsheet::XLSX::Utility2007 Related Software

About SoftwareSea