SharePoint Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 2963 Page Views: 

What are major components of SharePoint Excel Services?



Posted By: Avi Date: 25 November 2009 06:14:37 AM
 Answer:

There are three core Excel Services components:

1) Excel Web Access:
Excel Web Access is an Excel Services Web Part in Office SharePoint Server 2007 that renders (in other words, creates the HTML for) live Excel workbooks on a Web page, and allows the user to interact with those workbooks and explore them. Excel Web Access is the visible Excel Services component for the user. You can use Excel Web Access like any other Web Part in Office SharePoint Server 2007. Excel Web Access does not require anything to be installed on the user's client computer.

2) Excel Web Services:
Excel Web Services is the Excel Services component that provides programmatic access to its Web service. You can develop applications that call Excel Web Services to calculate, set, and extract values from workbooks, as well as refresh external data connections. Using Excel Web Services, you can incorporate server-side workbook logic into an application, automate the updating of Excel workbooks and create application-specific user interfaces around server-side Excel calculation.

3) Excel Calculation Services:
The role of Excel Calculation Services is to load workbooks, calculate them, call custom code (user-defined functions) and refresh external data. It also maintains the session state for interactivity. Excel Calculation Services maintains a session for the duration of interactions with the same workbook by a user or caller. A session is closed when the caller explicitly closes it or when the session times out on the server. Excel Services caches the opened Excel workbooks, calculation states, and external data query results, for improved performance when multiple users access the same set of workbooks.


Posted By: eTechPlanet

Date: 25 November 2009 06:14:37 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image NjU6vI
Related Questions
SharePoint : where are the different file to content query webpart? To design a page?

where are the different file to content query webpart? To design a page?

content query webpart displays a dynamic view of sites ,pages
Category: SharePoint Date: 4/21/2010 10:06:49 PM
SharePoint : How do I connect database and infopath in sharepoint?

How do I connect database and infopath in sharepoint?

\\.\pipe\mssql$microsoft## ssee\sql\query (for Sharepoint 2007) or \\.\pipe\mssql$sharepoint\sql\que....
Category: SharePoint Date: 4/21/2010 10:06:16 PM
SharePoint : how do I import datagrid in sharepoint through webparts?
SharePoint : how will u deploy features?

how will u deploy features?

First develop a SharePoint Feature by either copying an existing Feature and do modification on top ....
Category: SharePoint Date: 4/21/2010 10:01:08 PM
SharePoint : have worked in BDC?

have worked in BDC?

BDC stands for Business Data Catalog. It is a new feature introduced in Microsoft Office SharePoint ....
Category: SharePoint Date: 4/21/2010 10:00:38 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories