NAME
Spreadsheet::ConvertAA - Perl extension for Converting Spreadsheet column name to/from decimal
SYNOPSIS
use Spreadsheet::ConvertAA ;
my $baseAA = ToAA(475255) ;
my $base10 = FromAA('AAAZ') ;DESCRIPTION
This module allows you to convert from Spreadsheet column notation ( 'A', 'AZ', 'BC', ..) to decimal and back. The Spreadsheet column notation is base 26 _without_ zero. 'A' is 1 and 'AA' is 27. I named the base 'AA' because I found no better name.
ToAA taked a base 10 numbers in the range [0 .. 475254]. 0 (zero) is special and converted to '@'. FromAA takes a string in the range [A-Za-z]{1,4}.
Spreadsheet::ConvertAA 'confess' on invalid input.
Convertion is done in the range: 'A' .. 'ZZZZ' which corresponds to 1 .. 475254.
EXPORT
ToAA and FromAA
AUTHOR
Khemir Nadim ibn Hamouda. <nadim@khemir.net>
Copyright (c) 2004 Nadim Ibn Hamouda el Khemir. All rights
reserved. This program is free software; you can redis-
tribute it and/or modify it under the same terms as Perl
itself.If you find any value in this module, mail me! All hints, tips, flames and wishes are welcome at <nadim@khemir.net>.