Configure the Excel Web Access Function and Application of Excel Service

Excel services Moss2007 It is also a new server-side technology, which is built on ASP. NET And Microsoft Windows SharePoint Services 3.0 Technology. Before introducing the application of Excel services, it is necessary to understand the main functions of Excel service, so that we can better apply this technology. Excel services mainly includes three main application functions: 1, Yes Excel Web access. That is, through the browser Excel Access from the workbook . 2. YesExcel Web services, mainly Program Provides a programmable interface. This facilitates programmers Excel For access and computing. 3. Yes Excel calculation services Is the basis of the above two functions. Main Responsibilities Excel Workload loading, computing, and calling UDF (User-Defined Functions) And refresh external data.
But in this articleArticle Describes how to configure and applyThe Excel Web access function is detailed in the following process:
First, configure the Excel Web access function of Excel services.
Step 1:
(1) create a document library on the site such as (http: // cdh10000) named "Excel database ", select "Microsoft Office Excel 97-2003 Workbook" as the document template, as shown in figure
Click "CREATE ".
(2) Start Moss In Excel calculation services Service . Go to the SharePoint Management Center ----> operation ----> [topology and Service] server, and start the Excel calculation services service.
(3) set the document library to a trusted file location for Excel services. Go to shared service management ----> [Excel services settings] trusted file location, for example:

Enter the trusted file location and add the trusted file location (the URL of the document library you just created), for example:


OK. For example:

(4) return to the "Excel database" document library on the site, click Settings> document library Settings> [General settings] advanced settings, and select"Displayed as webpage", OK. As shown in:

So far, the Excel Web access function of the Excel database has been configured.
The second is application and view results.
Step 2:
(1) Create an Excel file on the desktop, calculate the C2, C3, C4 summary to C6, and name the C2, C3, and C4 cells as the business department amount and Information Department amount respectively, the quota amount is then displayed in a chart.

Save the document and upload it to "Excel database".

OK. At this time, we can go back to the Excel database to view the results. Click the test document to see the results, as shown in:

Well, some configuration and application functions have been completed.
(2) The following describes how to publish an Excel document to a Sharepoint Server. Also, open the test document .xlsx ",
Click the Office circle ----> Publish ----> Excel services in the upper left corner of the document, for example:

Open the "Save as" dialog box, find the "Excel database" document library under the site, and click "Excel services option", as shown in

In the "show" option, select the worksheet to be displayed and add parameters in the "Parameters" option, as shown in:

OK ----> OK ----> Save (you can replace the existing document ). Open a new ie window and find that the display window of the previous ie document has changed. a toolbar is added to the right, for example:

Enter the corresponding values in each parameter, as shown in:

At this time, the values in the workbook have also changed, the calculation formula has also changed, and even the chart has been changed. This also shows that the Excel version of IE also supports the calculation formula. As shown in figure: