Spreadsheet::WriteExcel::Utility 2.18

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

SYNOPSIS

Functions 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"); # 37389

This 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_col

Date 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_US

All 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

Product's homepage

Requirements:

· Perl