Spreadsheet::WriteExcel::Utility Spreadsheet::WriteExcel::Utility module contains helper functions for Spreadsheet::WriteExcel.
Download

Spreadsheet::WriteExcel::Utility Ranking & Summary

Spreadsheet::WriteExcel::Utility Tags

Perl module functions helper helper functions

Spreadsheet::WriteExcel::Utility Description

Spreadsheet::WriteExcel::Utility module contains helper functions for Spreadsheet::WriteExcel. Spreadsheet::WriteExcel::Utility module contains helper functions for Spreadsheet::WriteExcel.SYNOPSISFunctions to help with some common tasks when using Spreadsheet::WriteExcel.These functions mainly relate to dealing with rows and columns in A1 notation and to handling dates and times. use Spreadsheet::WriteExcel::Utility; # Import everything ($row, $col) = xl_cell_to_rowcol('C2'); # (1, 2) $str = xl_rowcol_to_cell(1, 2); # C2 $str = xl_inc_col('Z1' ); # AA1 $str = xl_dec_col('AA1' ); # Z1 $date = xl_date_list(2002, 1, 1); # 37257 $date = xl_parse_date("11 July 1997"); # 35622 $time = xl_parse_time('3:21:36 PM'); # 0.64 $date = xl_decode_date_EU("13 May 2002"); # 37389This module provides a set of functions to help with some common tasks encountered when using the Spreadsheet::WriteExcel module. The two main categories of function are:Row and column functions: these are used to deal with Excel's A1 representation of cells. The functions in this category are: xl_rowcol_to_cell xl_cell_to_rowcol xl_inc_row xl_dec_row xl_inc_col xl_dec_colDate and Time functions: these are used to convert dates and times to the numeric format used by Excel. The functions in this category are: xl_date_list xl_date_1904 xl_parse_time xl_parse_date xl_parse_date_init xl_decode_date_EU xl_decode_date_USAll of these functions are exported by default. However, you can use import lists if you wish to limit the functions that are imported: use Spreadsheet::WriteExcel::Utility; # Import everything use Spreadsheet::WriteExcel::Utility qw(xl_date_list); # xl_date_list only use Spreadsheet::WriteExcel::Utility qw(:rowcol); # Row/col functions use Spreadsheet::WriteExcel::Utility qw(:dates); # Date functions Requirements: · Perl

Spreadsheet::WriteExcel::Utility Related Software