Microsoft Office Tutorials and References
In Depth Information
Understanding Operational Concepts
Each SharePoint web application and site has an instance of the web service. You must access the API
from the correct site to ensure that the site context is used for authentication and authorization. For
example, the URL of the API for the web application at http://vServer is the following:
http://vServer/_vti_bin/ExcelService.asmx
And the URL of the API for the site at http://vServer/site is the following:
http://vServer/site/_vti_bin/ExcelService.asmx
Chapter 14 provides more details about using the API.
Understanding Operational Concepts
This section drills down into various aspects of these components and their interactions. It starts with a
discussion about sessions , which are the isolation unit for the user and provide the context in which all
the operations run. Sessions start when users open a workbook, and end when they close the workbook
or when the session times out. The state of a session is private to the user of the session, and it is not seen
by other sessions.
The discussion then examines the concepts related to performing requests (or operations) on the server.
Examples of such requests are opening a workbook, paging down, filtering a table, and drilling in a
pivot table.
Next, you will look into the process of publishing workbooks to the server and loading them. Publishing
is the process of putting an Excel workbook in a location from which the server can load it (such as
a SharePoint document library). On the server, the file gets downloaded to the ECS machine and then
loaded into memory.
The ECS caches workbooks and other objects in memory to improve performance. You will explore the
various settings that affect the caching and how those affect the behavior of the server.
You will also look at the basics of querying external data. The full details on this complex matter are in
Chapter 5.
Next, you will learn about ways to scale out the server and to load-balance.
The discussion concludes with a look at how ECS threads are used to service requests.
Sessions
Any interaction that a user has with a workbook is done in the context of a session . A new session is
automatically started every time a user opens a workbook. It may continue with additional user interactions,
such as refreshing data or filtering a table, and it ends when the workbook is closed or after a timeout.
Opening a workbook is always done in the context of a new session. A user may open multiple sessions
with the same workbook or with different workbooks. Each EWA instance on a Web Part Page will result
Search JabSto ::




Custom Search