my $LastRow = $worksheet->UsedRange->Find({What=>"* ",
SearchDirection =>xlPrevious,
SearchOrder=>xl ByRows})->{Row};
my $LastCol = $worksheet->UsedRange->Find({What=>"* ",
SearchDirection =>xlPrevious,
SearchOrder=>xl ByColumns})->{Column};
From this code I get the number of rows and columns used.
But how do I find out the first row and the column that is used in an excel sheet using Perl?
SearchDirection =>xlPrevious,
SearchOrder=>xl ByRows})->{Row};
my $LastCol = $worksheet->UsedRange->Find({What=>"* ",
SearchDirection =>xlPrevious,
SearchOrder=>xl ByColumns})->{Column};
From this code I get the number of rows and columns used.
But how do I find out the first row and the column that is used in an excel sheet using Perl?