I am trying to create an event handler that, when an excel document is checked into a sharepoint document library, will read through the document and pull out some key fields and insert them into an SQL database.
So far I have managed to create the event handler, and capture the checkin event, and I have been able to get reference to the document in the form of an SPFile object which seems to be a container for the binary data of the file.
My question is, how do I access this data? Where do I find the .NET classes that will allow me to, for example, read the contents of cell "A1" of the first worksheet in the checked in Excel file?
So far I have managed to create the event handler, and capture the checkin event, and I have been able to get reference to the document in the form of an SPFile object which seems to be a container for the binary data of the file.
My question is, how do I access this data? Where do I find the .NET classes that will allow me to, for example, read the contents of cell "A1" of the first worksheet in the checked in Excel file?