Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re: split cells

by McDarren (Abbot)
on Feb 20, 2012 at 11:00 UTC ( #955043=note: print w/replies, xml ) Need Help??

in reply to split cells

Is there any way to split the data in the cells using perl?

  1. Open the worksheet using your favourite Excel processing module
  2. Read the data from each cell
  3. split on whitespace
  4. Write the data back into the worksheet


Replies are listed 'Best First'.
Re^2: split cells
by bimleshsharma (Beadle) on Feb 20, 2012 at 11:35 UTC
    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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://955043]
[Your Mother]: I liked that show a lot.
[Your Mother]: Packed with minority women.
[LanX]: pitty they burned the actors in Stargate
LanX ... uhm ... wait...
[Eily]: LanX I don't see the woman
[LanX]: at the right, tanned , gib boobs, chains
[LanX]: big

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (11)
As of 2018-03-19 14:46 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (240 votes). Check out past polls.