Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

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

by orbital (Scribe)
on Mar 20, 2001 at 19:36 UTC ( [id://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?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (2)
As of 2024-04-16 07:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found