Make Excel Excel in SharePoint
October 19, 2011
Excel must be a hot app to use within, next, and through SharePoint. We prefer to create calculation “leaves” and the put the numerical goodies in a document with explanations. But we realize that the ArnoldIT goslings are in the minority.
Some employees and executives live in an Excel spreadsheet; their entire workday is focused on numbers, shortcut codes, and little white boxes. They use the data organization program for keeping track of numbers and word processing, but sometimes it doesn’t work well with SharePoint. The Apps4Rent blog brought to our attention “Excel Services in SharePoint,” a write-up about the Excel Services app. The app is built on ASP.Net and SharePoint technologies and has many core components that streamline the collaboration between the two programs. Many features are the Excel web service, UDFs, ECMAScript, Representational State Transfer service, Excel calculation services, custom applications, and much more. We learned:
Above all this, in multiple server configurations, Excel Services load-balances requests across multiple Excel Calculation Services occurrences in a farm configuration. If your installation includes multiple application servers, Excel Services will balance the load in an attempt to help ensure that no single application server is overloaded by requests.
Excel is a common part of many workers’ daily life and so is SharePoint. Using Excel Services to generate content will not only make some SharePoint users’ workload more efficient, but if you rely on SurfRay Ontolica, users will be able to find the content.
Whitney Grace, October 19, 2011
SurfRay
Comments
One Response to “Make Excel Excel in SharePoint”


That sounds like a really cool solution