This works for me:
my $Sheet = $Workbook->Worksheets(9); # select worksheet number 9
$Sheet->Delete;
Hsu, David wrote:
Can someone let me know the syntax of deleting a worksheet in an Excel workbook. I am using Win32::OLE.
I've tried:
$Workbook->Worksheets{9}.Delete;
_______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
