DiGregorio, Dave wrote:
> So that gives me the ASCII Value.  But I am looking for the 1-for-1
> value. A = 1
> B = 2
> C = 3
> ....
> AA = 27
> AB = 28
> 
> As the columns in Excel is are labeled
> 
> So I have a Value at max row AN which is 40 Columns in the Excel
> Worksheet. Using the below method gives me decimal value 104 which is
> 'H' and I do pull this value.  Any Ideas??

The module Spreadsheet::WriteExcel::Utility (part of
Spreadsheet::WriteExcel) contains various routines for dealing with this
kind of thing.

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Reply via email to