|Think about Loose Coupling|
Re: Using Win32::OLE and Excel - Tips and Tricksby Anonymous Monk
|on Jun 25, 2002 at 17:06 UTC||Need Help??|
Very good and useful article!!!
By the way, I'm using it to update values on Excel, but I'd like to know if it's possible to update a cell while the excel file is open. I tried the simple way :
my $oExcel = Win32::OLE->new('Excel.Application','Quit');
my $oBook = $oExcel->Workbooks->Open("$excelFile");
my $oSheet = $oBook->Worksheets(1);
But it doesn't seem to work...