Hey guys I have a problem with the speed of one part of my perl script. My script deals with a manipulation of a excel file.
The part where the speed is very low is a nested loop and I have no idea how to avoid that. I can show you the part:
use strict;
use warnings;
use Win32::OLE;
use Win32::OLE qw(in with);
use Win32::OLE::Const "Microsoft Excel"
for ($begincol;$begincol<$totcol;$begincol++) {
for ($beginrow;$beginrow<$maxrows;$beginrow++) {
my $cap = $Sheet2->Cells($beginrow,5)->{'Text'};
my $app = $sheet2->Cells(3,$begincol)->{'Text'};
my $yes = "yes";
if (index($app, $cap) != -1) {
$Sheet->Cells($beginrow,$begincol)->{Value} = $asis;
}
}
$beginrow = 7;
}