P is for Practical | |
PerlMonks |
Re: Using Win32::OLE and Excel - Tips and Tricksby Anonymous Monk |
on Jun 25, 2002 at 17:06 UTC ( [id://177139]=note: 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 Section
Tutorials
|
|