Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Hi all
I am trying to delete an Excel Worksheet Sheet2 through perl.
The part of the code is as below
But when I execute this, Excel will ask for deletion conformation. it pops up a menu sayinguse Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; use Win32::OLE::Variant; use Win32::OLE::NLS qw(:LOCALE :DATE); use Win32::OLE; use Win32::OLE::Const; #use Win32::API; $Win32::OLE::Warn = 3; # die on errors... my $Constant = Win32::OLE::Const->Load('Microsoft Excel'); $Excel = Win32::OLE->new('Excel.Application', 'Quit') || die "Error launching MS Excel ".Win32::OLE->LastError; $Book = $Excel->Workbooks->Add; $Sheet = $Book->Worksheets(1); $Sheet->{Name} = "Sheet1"; $Excel->WorkSheets("Sheet2")->Delete();
Now How can a sheet in Excel be deleted such that excel will not ask for any conformation? Thanks in advanceThe selected Sheet(s) will be permanently deleted. . to delete the selected sheets, click ok . to cancel the deletion click, cancel
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Delete a sheet from Excel
by planetscape (Chancellor) on Sep 12, 2005 at 09:02 UTC | |
by Anonymous Monk on Sep 12, 2005 at 09:45 UTC | |
by planetscape (Chancellor) on Sep 12, 2005 at 10:00 UTC | |
by Anonymous Monk on Sep 12, 2005 at 10:25 UTC | |
by Anonymous Monk on Aug 07, 2007 at 14:06 UTC | |
by planetscape (Chancellor) on Aug 07, 2007 at 19:46 UTC | |
Re: Delete a sheet from Excel
by marto (Cardinal) on Sep 12, 2005 at 09:08 UTC |
Back to
Seekers of Perl Wisdom