Re^2: Moving data in a tree

[wade]

Interesting. I'd have done this a little differently. When you are traversing the tree and you are done processing a node, check to see if it only has one leaf. If so, move the single leaf to its parent node (deleting children that have no leaves). The end result would be the same (i.e., branches with single leaves would get moved to the root) but this would allow nodes that wouldn't make it all the way to the root to be propagated as high as they could be.

Of course, that's not what the OP actually requested so I could be full of...er, um...I could be wrong.

[hoffmann]

Would it be possible to load the excel file as is, then run the perl script on it?

[wade]

In general, if I don't have a memory crisis, I'd:

• read the whole file into a suitable data structure,
• manipulate the data structure, and
• write the data structure out to a new file.

That makes things easier to code and, since you have before and after files, easier to check.

[ysth]

Not sure what you mean by "load" or "as is". Do you want something like Spreadsheet::ParseExcel?