Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: How can make a consult from M$ Excel to a perl program?

by orbital (Scribe)
on Mar 20, 2001 at 19:36 UTC ( #65705=note: print w/replies, xml ) Need Help??

in reply to How can make a consult from M$ Excel to a perl program?

Here is a Win32::OLE example:

use Win32::OLE; # If Excel is already running it uses the copy in memory eval {$ex = Win32::OLE->GetActiveObject('Excel.Application')}; if ($@) { $ex = Win32::OLE->new('Excel.Application', sub {$_[0]->Quit;}) or die; } # open an existing workbook $book = $ex->Workbooks->Open( 'yourdoc.xls' ); #write to a cell $book->Worksheets(1)->Cells(1,1)->Value = "whatever"; #save and exit $book->Save; undef $book; undef $ex;
This should get you pointed in the right direction, if you are looking for more documentation check out some of the previous issue of "The Perl Journal" I know there was some good write up in there, and also O'Reillys Perl Resource Kit Win32 Edition has more then enough to tackle this type of job.

check this review as well Spreadsheet::WriteExcel

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://65705]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2023-09-26 05:21 GMT
Find Nodes?
    Voting Booth?

    No recent polls found