Spreadsheet::WriteExcel::UtilitySpreadsheet::WriteExcel::Utility module contains helper functions for Spreadsheet::WriteExcel. | |
Download |
Spreadsheet::WriteExcel::Utility Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- John McNamara
- Publisher web site:
- http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.18/lib/Spreadsheet/WriteExcel/Utility.pm
Spreadsheet::WriteExcel::Utility Tags
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