Help With OLE

[DiGregorio, Dave]

Hey All,

            So I am building this app that parses and Excel spreadsheet for
a value based on the last column in the file.  But, I seam to return the
Numeric value as opposed to the Alpha Value.  Is there an easy way to get
around this??

 

$LastCol = $ReadSheet->UsedRange->Find({What=>"*",

    SearchDirection=>xlPrevious,

    SearchOrder=>xlByColumns})->{Column};

 

 

print "$LastCol\n" ; 

$ReadData = $ReadSheet->Range($LastCol.'4')->{Value} ;

 

 

 

Thanks

 

 

 

David R. DiGregorio

703 Rodi Road

Pittsburgh, PA 15235

p. 412-349-2440

[EMAIL PROTECTED]