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

Re: inserting parsed results into excel rows and columns in delimited format

by Trimbach (Curate)
on Feb 10, 2005 at 22:40 UTC ( #429936=note: print w/ replies, xml ) Need Help??


in reply to inserting parsed results into excel rows and columns in delimited format

Once your data is in @file why not something like this:

my ($row, $col) = ("A", 1); for (@file) { $Sheet->Range($row.$col)->{'Value'} = $_; $col++ }
Of course, this only handles one row. You can increment through the rows as well, using the automagical ++ incrementer on $row. BTW, when you have delimited files you should be thinking "split/join" and if you have fixed-width files you should be thinking "unpack/pack". Regex's should be your last choice in those situations. :-)

Gary Blackburn
Trained Killer


Comment on Re: inserting parsed results into excel rows and columns in delimited format
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://429936]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2015-07-28 06:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (252 votes), past polls