Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

perl copy multiple worksheets

by Appy16 (Sexton)
on Mar 09, 2010 at 11:27 UTC ( #827517=perlquestion: print w/replies, xml ) Need Help??

Appy16 has asked for the wisdom of the Perl Monks concerning the following question:

I am new to Perl and i've been assigned a project in which i have to copy or merge multiple worksheets to a new workbook. Someone asked me to use win32::OLE but i can't use that because i am working on a unix system (OS X to be precise.) i would be thankful if someone could help me out.

Replies are listed 'Best First'.
Re: perl copy multiple worksheets
by Corion (Patriarch) on Mar 09, 2010 at 11:37 UTC
Re: perl copy multiple worksheets
by tweetiepooh (Hermit) on Mar 09, 2010 at 15:06 UTC
    You can use Spreadsheet::ParseExcel to read .xls files and Spreadsheet::WriteExcel to create your merged file.

    You may need to take care of formatting and the like. If your data set is large you may need to look at Spreadsheet::WriteExcel::Big.

Log In?

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

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (2)
As of 2023-11-29 04:46 GMT
Find Nodes?
    Voting Booth?

    No recent polls found