Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^2: split cells

by bimleshsharma (Beadle)
on Feb 20, 2012 at 11:35 UTC ( #955050=note: print w/ replies, xml ) Need Help??


in reply to Re: split cells
in thread split cells

Yes, follow up below:
* import module to parse xls. (This will help to modify your same cell of same file)
* Read that cell text.
* Split that cell text into newline. (@line=split '\n',cellvalue)
* Split that line into tabspace (@innerline=split '\t',$line(index)
* Now write each index position value of @innerline into different cells.
Hope this will help.


Comment on Re^2: split cells
Replies are listed 'Oldest First'.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (14)
As of 2015-07-07 16:29 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 (91 votes), past polls