Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Spreadsheet::XLSX::UtiUser2Contributed Perl DSpreadsheet::XLSX::Utility2007(3)

NAME
       Spreadsheet::XLSX::Utility2007 -	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, "\n";	      #	23459.5070717593

	   #Convert Excel Time -> localtime
	   my @aBirth =	ExcelLocaltime($iBirth,	undef);
	   print join(":", @aBirth), "\n";   # 11:10:12:23:2:64:1:0

	   #Formatting
	   print ExcelFmt('yyyy-mm-dd',	$iBirth), "\n";	#1964-3-23
	   print ExcelFmt('m-d-yy', $iBirth), "\n";	# 3-23-64
	   print ExcelFmt('#,##0', $iBirth), "\n";	# 23,460
	   print ExcelFmt('#,##0.00', $iBirth),	"\n";	# 23,459.51
	   print ExcelFmt('"My Birthday	is (m/d):" m/d', $iBirth), "\n";
					     # My Birthday is (m/d): 3/23

DESCRIPTION
       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.

Functions
       This module can export 3	functions: ExcelFmt, ExcelLocaltime and
       LocaltimeExcel.

   ExcelFmt
       $sTxt = ExcelFmt($sFmt, $iData [, $i1904]);

       $sFmt is	a format string	for Excel. $iData is the target	value.	If
       $flg1904	is true, this functions	assumes	that epoch is 1904.  $sTxt is
       the result.

       For more	detail and examples, please refer sample/chkFmt.pl in this
       distribution.

       ex.

   ExcelLocaltime
       ($iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iwDay, $iMSec) =
		   ExcelLocaltime($iExTime [, $flg1904]);

       ExcelLocaltime converts time information	in Excel format	into Perl
       localtime format.  $iExTime is a	time of	Excel. If $flg1904 is true,
       this functions assumes that epoch is 1904.  $iSec, $iMin, $iHour,
       $iDay, $iMon, $iYear, $iwDay are	same as	localtime.  $iMSec means
       1/1,000,000 seconds(ms).

   LocaltimeExcel
       $iExTime	= LocaltimeExcel($iSec,	$iMin, $iHour, $iDay, $iMon, $iYear
       [,$iMSec] [,$flg1904])

       LocaltimeExcel converts time information	in Perl	localtime format into
       Excel format .  $iSec, $iMin, $iHour, $iDay, $iMon, $iYear are same as
       localtime.

       If $flg1904 is true, this functions assumes that	epoch is 1904.
       $iExTime	is a time of Excel.

   col2int
       $iInt = col2int($sCol);

       converts	a excel	row letter into	an int for use in an array

       This function was contributed by	Kevin Mulholland.

   int2col
       $sCol = int2col($iRow);

       convert a column	number into column letters NOET: This is quite a brute
       force coarse method does	not manage values over 701 (ZZ)

       This function was contributed by	Kevin Mulholland.

   sheetRef
       ($iRow, $iCol) =	sheetRef($sStr);

       convert an excel	letter-number address into a useful array address
       NOTE: That also Excel uses X-Y notation,	we normally use	Y-X in arrays
       $sStr, excel coord (eg. A2).

       This function was contributed by	Kevin Mulholland.

   xls2csv
       $sCsvTxt	= xls2csv($sFileName, $sRegion,	$iRotate);

       convert a chunk of an excel file	into csv text chunk $sRegions =
       "sheet-colrow:colrow" (ex. '1-A1:B2' means 'A1:B2' for sheet 1)
       $iRotate	 = 0 or	1 (output should be rotated or not)

       This function was contributed by	Kevin Mulholland.

AUTHOR
       Rob Polocz rob.polocz@trackvia.com based	on work	by for
       Spreadsheet::ParseExcel by Kawai	Takanori (Hippo2000) used with
       permission

SEE ALSO
       Spreadsheet::ParseExcel,	Spreadsheet::WriteExcel

COPYRIGHT
       This module is part of the Spreadsheet::XLSX distribution.

perl v5.32.1			  2015-04-22 Spreadsheet::XLSX::Utility2007(3)

NAME | SYNOPSIS | DESCRIPTION | Functions | AUTHOR | SEE ALSO | COPYRIGHT

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Spreadsheet::XLSX::Utility2007&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help