SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

we would like to

  • read an Excel template stored in a SharePoint 2010 library
  • create a new Excel file from it
  • fill the new Excel file with data programmatically

we tried already Excel Services but however the given MSDN example seems only to work while debugging...!?

what the best practise for the Szenario? better using cson or serverside ?


Any help appric. Thanks.

share|improve this question
up vote 1 down vote accepted

If you want to create and modify Office documents you'll need to work with a different technology, Open XML. You can download the Open XML SDK here:

More information is available here:

I didn't check up on it in detail, but this seems like a fairly decent tutorial using Open XML in SharePoint:

In your case I'd create a copy of the template and then put some Open XML magic on it.

It may look a little daunting at first, but it's a fairly simple and fun to use.

share|improve this answer
thank you Christoffel - open XML successfully tested! – Celophysis Aug 19 '14 at 5:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.