my $Range = $Sheet->Range($col.$startrow.":".$col.$endrow);

##</code><code>##

my $Range = $Sheet->Columns($colletter); 

##</code><code>##

my $Range = $Sheet->Rows($rownumber);