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

 

[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/com/readdocumentproperties.shtml

Structured Storage - The DocFile

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