1

Hope you can help me with this question:

I have a SP Library, where the user should type info into some fields (Text, Publishing HTML, Datetime). So, I'm wondering if it's possible to use that info to fill an Excel Template and save it to the Library item the user is adding?

Is this possible with Event receivers, or how would I achieve this goal?

Improve this question

1 Answer 1

Reset to default
0

Yes, you can accomplish this with an event receiver on ItemAdded (and potentially ItemUpdated). You can easily generate a standard XML or CSV file which can then be opened in Excel, or use the Open XML SDK to create native excel files (http://openxmldeveloper.org/).

If you wanted to have this work on 'ItemUpdated', you could lookup the existing excel document and regenerate it based on the latest listitem properties.

Some more info is here.

Improve this answer
2
  • If I got Sharepoint 2013 , could I create the event receiver for that library in Visual Studio 2010? Commented Feb 19, 2014 at 17:38
  • I haven't tried that exact combo myself, but according to this question it should work: stackoverflow.com/questions/13918826/… Commented Feb 19, 2014 at 17:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.