Nov 19, 2014, 7:18 AM
Post #31 of 46
Ah, so removing use of the regular expression qr quote operator worked. What version of Perl are you using out of interest.
Re: [Tejas] How to append or prepend a string to a variable
[In reply to]
If the condition is working fine, then you can leave it, but what if org doesn't match either '04', '2Y', '2R', '3S', '79', '3T', '3M' or '2H', how do you handle. Note it will also test this condition for all input files, you might need to chuck in $worksheet_id eq 'SL'. My preference would be to extend the input hash, perhaps add a handler / closure which orgs are run through.
Can i change this to ARGV and ARGV 
I might have more input files to , now they are just 2
You can replace the hardcoded filenames with @ARGV values i.e. path => $ARGV,, but if you you add more input files, you would have to extend the %input hash appropriately. If you want to build the %input hash dynamically, then you will have to supply all necessary info via args i.e. --GL.path=..., --GL.delim=..., --SL.path=..., --SL.delim=..., then parse them.
Finally, if you provide your final code once you have finished, I can take a look at it, re-look through the Excel::Writer::XLSX documentation and see if I can tidy / improve it as best as possible. My latest version was rushed.
(This post was edited by Zhris on Nov 19, 2014, 7:22 AM)