Win32 OLE MSExcel/MSword

[sanjeeb]

Hey
can any one please help to find all API listing of WIn32 OLE ,
especially for using word and excel sheet writing/reading. Any site
where all API lising and descriptions are there. I serched but cdnt
find the list , only examples i got.
With reagards
Sanjeeb

 

[Ben Morrow]

can any one please help to find all API listing of WIn32 OLE ,
especially for using word and excel sheet writing/reading. Any site
where all API lising and descriptions are there. I serched but cdnt
find the list , only examples i got.

I don't believe there is one specificly for Win32::OLE, but the API is
the same as you would use from VBA. So if you fire up Word (or Excel),
go into the macro editor and poke around in the object explorer window
(can't remember what it's called; it's a window with a big list of all
the classes defined in your current environment; it's on the left by
default) you should find what you need. Also, you could try the
Word/Excel help, or a Google search of msdn.microsoft.com.

Ben

 

[Dr.Ruud]

sanjeeb schreef:

can any one please help to find all API listing of WIn32 OLE ,
especially for using word and excel sheet writing/reading.

It should be here somewhere: http://msdn.microsoft.com

What do you need it for exactly?

See also:
http://search.cpan.org/search?m=module&q=excel&s=1&n=100
http://search.cpan.org/search?m=module&q=word&s=1&n=100
(between the first few hits)

 

[A. Sinan Unur]

I don't believe there is one specificly for Win32::OLE, but the API is
the same as you would use from VBA. So if you fire up Word (or Excel),
go into the macro editor and poke around in the object explorer window
(can't remember what it's called; it's a window with a big list of all
the classes defined in your current environment; it's on the left by
default) you should find what you need.

Use the Object Browser to find out the names of methods/properties and
very basic descriptions.

Word/Excel help, or a Google search of msdn.microsoft.com.

E.g. http://www.google.com/search?
as_q=worksheets&as_sitesearch=msdn.microsoft.com

or just navigating to the appropriate section of the MSDN library can do
wonders.

Sinan

--
A. Sinan Unur <[email protected]>
(remove .invalid and reverse each component for email address)

comp.lang.perl.misc guidelines on the WWW:
http://augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html

 

[l v]

Hey
can any one please help to find all API listing of WIn32 OLE ,
especially for using word and excel sheet writing/reading. Any site
where all API lising and descriptions are there. I serched but cdnt
find the list , only examples i got.
With reagards
Sanjeeb

Also don't forget about what is on CPAN (www.cpan.org) It offers modules
such as Spreadsheet::WriteExcel and Spreadsheet:arseExcel.

Len