Re: Unable to update correct corrosponding values in excel.

Hi,

I am getting below output.

You should be getting something like:

Possible attempt to separate words with commas at 11128268.pl line 4.
Useless use of subtraction (-) in void context at 11128268.pl line 4.
Argument "99999991,99999992,99999993,99999994,99999995" isn't numeric 
+in subtraction (-) at 11128268.pl line 4.
[download]

If you are not, it is because you are not using strict and warnings. Why not?! Seriously, why not? Please don't post another question until you are testing code with strict and warnings enabled. You are wasting everyone's time.

Also, the design of your application is just wrong. You should have this data in a database, or in hashes to begin with. However you are reading the data, don't read it into arrays. Read it into hashes.

Hope this helps!

The way forward always starts with a minimal test.

Comment on Re: Unable to update correct corrosponding values in excel. Select or Download Code

Replies are listed 'Best First'.

Re^2: Unable to update correct corrosponding values in excel.
by GrandFather (Saint) on Feb 11, 2021 at 23:43 UTC

It's worse than that. Even without strictures he should see:

Smartmatch is experimental at ...\noname.pl line 12.
Can't declare scalar dereference in "my" at ...\noname.pl line 6, near
+ "$no1 ="
Execution of ...\noname.pl aborted due to compilation errors.
[download]

Clearly not fit for posting. With strictures it is much more exciting:

Possible attempt to separate words with commas at ...\noname.pl line 4
+.
Possible attempt to separate words with commas at ...\noname.pl line 5
+.
Possible attempt to separate words with commas at ...\noname.pl line 7
+.
Useless use of a constant ("my") in void context at ...\noname.pl line
+ 7.
Useless use of a constant ("emp") in void context at ...\noname.pl lin
+e 7.
Useless use of a constant ("id,my") in void context at ...\noname.pl l
+ine 7.
Useless use of a constant ("emp") in void context at ...\noname.pl lin
+e 7.
Useless use of a constant ("id,my") in void context at ...\noname.pl l
+ine 7.
Useless use of a constant ("emp") in void context at ...\noname.pl lin
+e 7.
Useless use of a constant ("id,Not") in void context at ...\noname.pl 
+line 7.
Useless use of a constant ("my") in void context at ...\noname.pl line
+ 7.
Useless use of a constant ("empployee,Not") in void context at ...\non
+ame.pl line 7.
Useless use of a constant ("my") in void context at ...\noname.pl line
+ 7.
Useless use of a constant ("empployee,Not") in void context at ...\non
+ame.pl line 7.
Useless use of a constant ("my") in void context at ...\noname.pl line
+ 7.
Useless use of a constant ("empployee,Not") in void context at ...\non
+ame.pl line 7.
Useless use of a constant ("my") in void context at ...\noname.pl line
+ 7.
Smartmatch is experimental at ...\noname.pl line 15.
Can't declare scalar dereference in "my" at ...\noname.pl line 9, near
+ "$no1 ="
Global symbol "$worksheet" requires explicit package name (did you for
+get to declare "my $worksheet"?) at ...\noname.pl line 13.
Global symbol "$my_format" requires explicit package name (did you for
+get to declare "my $my_format"?) at ...\noname.pl line 13.
Global symbol "$worksheet" requires explicit package name (did you for
+get to declare "my $worksheet"?) at ...\noname.pl line 19.
Global symbol "$worksheet" requires explicit package name (did you for
+get to declare "my $worksheet"?) at ...\noname.pl line 25.
Global symbol "$r4" requires explicit package name (did you forget to 
+declare "my $r4"?) at ...\noname.pl line 25.
Execution of ...\noname.pl aborted due to compilation errors.
[download]

Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond

[reply]
[d/l]
[select]


Think about Loose Coupling
	PerlMonks