Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We are using Excel Web App for Sharepoint 2010.

We have customized page so we have added a button in a ascx control to add a row using open XML SDK 2.0. How can we refresh page in order to see the new row added to the Excel?

share|improve this question
add comment

1 Answer 1

I would try the EWA.Workbook.recalcAsynch method. There's a good example of it in this blog post.

The above example shows using a timeout to set a short delay before the control refreshes. If you wire this into the click event of your button, the delay might come in handy if you're adding a new row asynchronously.

If you're writing server code, it might provide a better alternative. I'm less familiar with the Excel Web Access Server APIs.

share|improve this answer
    
Thanks for your response, but I think Excel Web App doesn't support this methods, as shown in this comparison. I am newbie to Sharepoint 2010, so I'm not sure if it is possible to use them. –  Alfonso Oct 18 '11 at 7:19
add comment

Your Answer

 
discard

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.