How to access EXCEL file contents and properties

[vbvjain]

I am developing an application that requires me to read MS EXCEL file
and get its properties and contents. I could read only the contents i
a dataset by creating an object, but i could not figure out a way as t
how to get the properties such as Title, Name, Last Author, Date o
creation etc.
Can anyone tell me as to how should i achieve this, any API tha
provides me such functionality??
Thanks in advance
-
vbvjai
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------

[Ken Cox [Microsoft MVP]]

You need to access OLE Structured Storage

Dsofile.exe Lets You Edit Office Document Properties from Visual Basic and
ASP

http://support.microsoft.com/?scid=kb;en-us;Q224351

This sample project creates a DLL that you can use to get document
properties (including thumbnails) of Office files, .URL files and files
stored in NTFS5 partitions.

http://www.mvps.org/emorcillo/vb6/co...operties.shtml

Structured Storage - The DocFile

http://www.codeproject.com/file/stru...asp?print=true

"vbvjain" <vb************@mail.codecomments.com> wrote in message
news:vb************@mail.codecomments.com...

I am developing an application that requires me to read MS EXCEL files
and get its properties and contents. I could read only the contents in
a dataset by creating an object, but i could not figure out a way as to
how to get the properties such as Title, Name, Last Author, Date of
creation etc.
Can anyone tell me as to how should i achieve this, any API that
provides me such functionality??
Thanks in advance.

--
vbvjain
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------