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?
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.