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

Re: Joininig excel columns from many files

by Not_a_Number (Parson)
on Jul 27, 2011 at 19:28 UTC ( #917112=note: print w/replies, xml ) Need Help??

in reply to Joininig excel columns from many files

Hi, dtm81, and welcome to the Monastery.

First of all, I'd like to point out that when you post a question here, and one of the earliest replies requests further elucidation, it is considered bad form not to respond. In your case, dcmertens asked you:

What do you mean you need to store the data 'somewhere until all the files are parsed'? Does the amount of data exceed a RAM limitation or are you just inquiring how you would build the nested data structure?

More than four hours later, you still haven't replied.

Of course, you might have been unavoidably detained elsewhere, eg by having your house burned down. In which case, no apologies are necessary. Otherwise, if you return to this thread, please do dcmertens the decency to reply to his post.

Thank you

  • Comment on Re: Joininig excel columns from many files

Replies are listed 'Best First'.
Re^2: Joininig excel columns from many files
by dtm81 (Initiate) on Jul 28, 2011 at 11:39 UTC
    Fortunatelly i am currently working as well, so maybe you should think that i am busy working to something else... And i am very greatfull that peoples are trying to help here, thank you all for the quick solutions that you bother gave me :) To respond to our colegue's question, i usually write a script that will be OK for 20 lines as well as for 2 billions of lines, so i was thinking i will use threads to split the file in. As a quick solution, indeed i will export the file into a csv format and just the task to be done quick, but i ll want to "beatify" the script as i mentioned earlier. I think the solutions are more than enough, so i ll stop here... Cheers, to all!
      Had time this weekend, to "meditate" on it... The implementation was without external module, but with a "big" - hash of arrays, that i parsed it later on... It was in a way funny in the end, because i forgot to set the IFS to \r\n, reading from win files :) but finally thought of it... Any way i found a nice module: Spreadsheet::ExcelHashTable that is parsing the excel files straight into the hash... Thanks to all! Proud to be a part of this community.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://917112]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2017-02-26 18:44 GMT
Find Nodes?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?

    Results (376 votes). Check out past polls.