Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1017886]
help
Chatterbox?
[mz2255]: I'm trying to post a question to "seekers of perl wisdom" but always getting a permission denied when I want to submit. There are no links in my post...
[ambrus]: again? someone complained about this just a few days ago (although eventually they could post)
[choroba]: Can you post the question in mz2255's scratchpad?
[ambrus]: Corion, if you're here, can you check the spam filter logs to see what's triggering this time?

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (9)
As of 2017-10-19 15:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My fridge is mostly full of:

















    Results (255 votes). Check out past polls.

    Notices?