How to modify an Office (Word, Excel) file in sharepoint programmatically

Question

I need to Open and modify a document that resides on a Sharepoint Document Library.

These changes on the file are done during an event generated by a Document Library, so I must change it by code.

Is there any way to do that? I tried to use Microsoft.Office.Interop.Word but without success.

Thank you very much

Answer 1

Ziba,

OpenXML SDK is what you are looking for, OpenXML SDK can help you edit and create word, excel and other documents programmatically and it works great with SharePoint!

Following links can help you:
Modifying Open XML Documents using the SharePoint Object Model
SharePoint and OpenXML

ERIC White as written many articles on SharePoint with OpenXML:
http://ericwhite.com/blog/category/open-xml/

I hope this helps