Available methods and properties through OLE interface

[Greg Luce]

I'm trying to access Excel files from a Perl program using OLE. Where can I
find the available methods and properties for Excel?
Greg

 

[Jim Thomlinson]

That question is awfully open ended. There are potentially thousands of
properties and methods. Can you narrow down exactly what it is you wnat to
do...

 

[Greg Luce]

For starters, we are migrating our system from one database to another. We
have downloaded attachments from the database. For some reason, a lot of the
excel documents have their workbooks hidden. I would like to
programmatically unhide the workbooks.

However, I'm sure I may need to do additional things to the files. So I
would also like to know is there any place that would have a list of all the
methods/properties so I don't have to post a question for each action I would
like to do.

 

[Jim Thomlinson]

The big objects you will want to look at are most likely the application,
workbook, worksheet, and range.

In the VBE if you hit F2 you will get the object browser. There is a list of
all of the objects and their associated properties and methods...