By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,693 Members | 1,972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,693 IT Pros & Developers. It's quick & easy.

Perl copy Multiple Worksheets

P: 5
How Can I copy Multiple Excel Worksheets into a single Workbook using perl. I was using File::Copy but it over writes data.
Mar 8 '10 #1
Share this Question
Share on Google+
3 Replies


numberwhun
Expert Mod 2.5K+
P: 3,503
Have you looked at the bunch of modules available on CPAN for working with spreadsheets? Using them you can do a number of things with Excel spreadsheets, check them out.

Regards,

Jeff
Mar 8 '10 #2

jkmyoung
Expert 100+
P: 2,057
Is it possible to save the files as OfficeXML? It's is pretty easy to merge spreadsheets, in XML as each file is kind of like:

Preamble:
Spreadsheet1
Spreadsheet2
Endings

so you can just grab the entire spreadsheet from one file and insert it into another.
Mar 8 '10 #3

P: 5
@numberwhun
well i tried those but still not able to work it out.
Mar 9 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.