1

I'm wondering is it posible to create or modify Excel spreadsheets that are on SharePoint 2010 programaticaly and how to do it?

2 Answers 2

3

have a look at the OpenXML SDK. See link text for examples of what you can do.

2
  • Yes, it shows how you to work with Excel spreadsheet, but do Sharepoint allow such modifications? And example how to open spreadsheet in Sharepoint would be nice. Nov 22, 2010 at 13:56
  • I dig in further and found such great video that explains using of Open XML sdk and also has example of using it with SharePoint - msdn.microsoft.com/en-us/office/ff436082.aspx . Nov 26, 2010 at 7:39
0

You could also take a look at OfficeWriter, a product from SoftArtisans. It has the ability to create and modify Excel (and Word) documents programatically. OfficeWriter is much easier to work with than the OOXML SDK. It can also interact with SharePoint 2010 (and 2007). They have information about both OfficeWriter and it's SharePoint integration on their website at http://officewriter.softartisans.com/officewriter-434.aspx.


Full Disclosure - I work at SoftArtisans.

Your Answer

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

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