#my $LastRange = $LastCol.$LastRow; $LastRange = 'IV'.$LastRow; $ArrayData = $DataSheet-> Range("A1:$LastRange")->{Value};