in reply to Re^2: Moving data in a tree
in thread Moving data in a tree

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

Replies are listed 'Best First'.
Re^4: Moving data in a tree
by wade (Pilgrim) on Jul 21, 2008 at 21:36 UTC

    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.

    --
    Wade
Re^4: Moving data in a tree
by ysth (Canon) on Jul 22, 2008 at 06:45 UTC