in reply to Adding new workbook to existing excel
If you are in a Windows environment, you could use Win32::OLE to work with Excel. Adding a new worksheet can be done like this:
note: The line above has been taken from this great example, which you surely want to check out. HTH, Rata#___ ADD NEW WORKSHEET $workbook -> Worksheets -> Add({After => $workbook -> Worksheets($work +book -> Worksheets -> {Count})});
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Adding new worksheet to existing Excel workbook
by sundialsvc4 (Abbot) on Jan 29, 2013 at 13:30 UTC |
In Section
Seekers of Perl Wisdom