in reply to Perl-Excel Guidelines

You'll have to look for whether Microsoft has documented anything if you're going to use Win32::OLE. The module is a generic OLE interface; documentation for a specific applications API belongs into that specific application's documentation, not with Win32::OLE.

But you might be interested in Spreadsheet::ParseExcel and Spreadsheet::WriteExcel.

Makeshifts last the longest.

Replies are listed 'Best First'.
Re: Re: Perl-Excel Guidelines
by Grygonos (Chaplain) on Jul 16, 2003 at 16:39 UTC
    Open Excel.. choose tools..macros... visual basic editor..then click the object browser icon in the toolbar... its a box with 3 things coming out of it.
    Then you see the object browser. On the left you see the classes. On the right you see the methods. to receive help on a selected method you have to hit the question mark on the object browser window with the method or class selected.
    just a note.. with ole you reference methods and properties like so
    my $excel  = Win32::OLE->new("Excel.Application");
$excel->{someproperty}
$excel->somemethod();

    [download]
    For collections of objects such as worksheets, you can either use 
    $excel->collection($someindex) ;
||
$excel->collection->Item($someindex);

    [download]
    to reference specific items in the collection. Hope this helps.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom