SharePoint 2010: working with Excel files

i am developing a SP2010 site on which i want to store some data files in xls format. here is the logic of how it works: 1) the user uploads file to specific data library. 2) the data from the file must be parsed and put into a 开发者_JAVA技巧list.

so here's the question: how can i parse an excel file inside an event receiver? are there any other tools besides excel services?

Your best option will be the OpenXML framework:

• Download
• Reading Data from SpreadsheetML

The only downside of this approach is that this framework only works with Office 2007/2010 documents.

If you have to use Office 2003 documents, you might want to have a look at Office Automation, which requires installing Office on the (SharePoint) Server:

• How to automate Microsoft Excel from Microsoft Visual C#.NET