how to create a new worksheet in Excel Services

Question

Hi,

I'm new in Excel Services and wondering can I create a new worksheet in a workbook or copy worksheet with Excel Services programmatically ?

Because I just read that Excel Services enable us to save the workbook to the Sharepoint Doc Library/stream/local file.

thx

---

rus

Answer 1

You cant use Excel Services to create a new sheet or to save back into point in SharePoint 2007.

You can use the SharePoint APIs and the OpenXML APIs to do that though.

---

Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864

Answer 2

You cant use Excel Services to create a new sheet or to save back into point in SharePoint 2007.

You can use the SharePoint APIs and the OpenXML APIs to do that though.

---

Shahar Prish Blog: http://blogs.msdn.com/CumGranoSalis Professional Excel Services: http://www.amazon.com/Professional-Excel-Services-Programmer/dp/0470104864

Hi, thanks for the reply, do you have code example for doing that way ?

---

rus