http://www.perlmonks.org?node_id=1015874


in reply to Re: Adding new worksheet to existing Excel workbook
in thread Adding new workbook to existing excel

I definitely concur with this.   Fire up the Excel application in this manner, and tell it what you want it to do.

It took Microsoft a bunch of years to finally get OLE “really right,” and for computers to grow-up enough to easily handle it ... but ... they did and they did.   Do it that way.

  • Comment on Re^2: Adding new worksheet to existing Excel workbook