Help for this page

Select Code to Download


  1. or download this
    my $Excel =  Win32::OLE->GetActiveObject('Excel.Application');
    unless ($Excel) {
    ...
    }
    my $xls = $Excel->Workbooks->Open(...);
    my $sheet = $xls->Worksheets(1);
    
  2. or download this
     my $lastrow = $sheet->UsedRange->Find(
            {   What            => "*",
    ...
                SearchOrder     => xlByRows
            }
        )->{Row};