in reply to Perl parse excel and duplicate rows
I'm trying to parse an excel for searching some issue codes. In the excel sheet, I look for 'Work Notes' column and try to search for Issue code. If there is more than One issue code, i need to duplicate the row for each Issue code. Could you please help me.. here is what i've tried so far...
Which part are you having trouble with? Parsing the excel? Finding the 'Work Notes' column? Searching for the Issue code? Duplicating the row in the output?
Could you post less code that focuses on the part you're having trouble with, and explains what you expect, what you're getting, etc.? I don't have time right now to slog through 100+ lines of code, but 10-20 might be doable. Thanks.