Perl copy Multiple Worksheets

[appu123]

How Can I copy Multiple Excel Worksheets into a single Workbook using perl. I was using File::Copy but it over writes data.

[numberwhun]

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

[jkmyoung]

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.

[appu123]

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

well i tried those but still not able to work it out.