Think about Loose Coupling | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | 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); ... $oBook->Save; $oBook->Close; But it doesn't seem to work... Any idea???? Thanx In reply to Re: Using Win32::OLE and Excel - Tips and Tricks
by Anonymous Monk
|
|