Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: Perl parse excel and duplicate rows

by runrig (Abbot)
on Feb 08, 2013 at 21:05 UTC ( #1017886=note: print w/replies, xml ) Need Help??

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.

  • Comment on Re: Perl parse excel and duplicate rows

Replies are listed 'Best First'.
Re^2: Perl parse excel and duplicate rows
by doubledecker (Scribe) on Feb 09, 2013 at 03:30 UTC
    I am having problem with duplication of rows

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1017886]
NodeReaper tries to shade his eye-sockets with his hands

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (6)
As of 2017-01-23 06:47 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (191 votes). Check out past polls.