Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: Joininig excel columns from many files

by wallisds (Beadle)
on Jul 27, 2011 at 18:15 UTC ( #917092=note: print w/replies, xml ) Need Help??

in reply to Joininig excel columns from many files

I think you can accomplish your goal by using a combination of two CPAN modules: Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. Use ParseExcel to get the data from the 20 excel files while using WriteExcel to add the data (organized as you like) to a new sheet using WriteExcel.

Since the columns are not in the same order on each sheet you'll need to get the value of A1, B1, .... G1 for the names of the columns. As long as the naming convention is the same in each sheet you should be able to keep all the data together by an IF statement.

  • Comment on Re: Joininig excel columns from many files

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (7)
As of 2023-01-31 10:05 GMT
Find Nodes?
    Voting Booth?

    No recent polls found