Copying/pasting worksheets in Excel

[Nebbish]

Hey folks, slightly tricky one for ya. I'm using Perl to take a bunch of information from one workbook, and put it in several others. I'm fairly proficient in using the CPAN WriteExcel/ParseExcel modules. The problem is, every sheet in every workbook I'm creating needs to be built from a template worksheet I have, but I can't find any way to "copy and paste" the whole sheet from Perl the way you can working directly with Excel. Creating each workbook and worksheet by hand is a possibility, but I have about 60+ worksheets I'd be creating. Obviously I'd much rather have Perl do the work.

Thanks in advance,

Nick

 

[PaulTEG]

Can you use cut and paste in either module?
--Paul

It's important in life to always strike a happy medium, so if you see someone with a crystal ball, and a smile on their face ... smack the fecker

 

[Nebbish]

Not that I'm aware of. Seems like ParseExcel does just that, and WriteExcel does just that, but neither have anything to do with copying or pasting. I suppose I could write my own copy-and-paste-sheets function, but I don't really have the time or energy.