Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2018-06-24 22:43 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (126 votes). Check out past polls.