Go to Excel Web access Web Part

Http://office.microsoft.com/zh-cn/sharepoint-server-help/HA010377880.aspx? CTT = 5 & origin = ha010377881

 

Excel Web access web part Summary

Applicable to: Microsoft SharePoint Server 2010

Print

The Excel access web part is a Microsoft SharePoint Server 2010 technology used to display an Excel Workbook from a document library. You can connect an Excel Web access part to any workbook in the SharePoint document library and use it on a dashboard or other SharePoint pages. For example, you may want to display the selected elements of a quarterly report on a dashboard.

You can display the entire workbook that contains multiple worksheets in a single Excel Web access web part, or select only one element of the workbook to publish the workbook as a named project. For example, you can divide the source workbook into multiple parts (based on a single worksheet, named project, or other objects) and publish these parts separately. Then, you can connect separate parts to each Web part, and control the access to each part of the workbook by configuring permissions on the Web Part Page. In addition, you can connect published Web components to each other to achieve cross-filtering and Dynamic Data refreshing. Finally, the Excel Web access web parts can be reused. If necessary, the same Excel Web access web parts can be used on many different web pages.

When using Excel access web components, you can easily and securely share reports, analyze, and browse data with other users. In this article, you can find links to the Excel Web access web components and help topics on how to publish workbooks to excel services.

Content

• What is an Excel Web access part?
• How can I display a workbook in an Excel Web access web part?
• How to publish a workbook?

What is an Excel Web access part?

The workbook displayed in the Excel Web access web part looks similar to Microsoft Excel. For example, a workbook in the Excel Web access web part can have a worksheet tab, outline button, and drop-down arrow. Microsoft SharePoint Server 2010 provides many methods to customize Web components.

The top contains the title and a toolbar with multiple menus, commands, and drop-down lists. The main window displays one or more worksheets (in the worksheet view) or a named project, table, or Excel table (in the named project view ). In addition, the main window may display the outline of the workbook content. Displayed when parameters are defined in the source workbook "Parameter"The pane has a labelled text box (data input for defining parameters) and provides optional tooltip for details about each parameter. The refreshing data message is displayed at the bottom.

How can I display a workbook in an Excel Web access web part?

To display a workbook in an Excel Web access web part, you must add the Web part to the Sharepoint Server 2010 page, connect the workbook to the Web part, and configure the Web Part properties.

The following articles help you get started.

Content	Description
Show an Excel Workbook in a Web Part	Provides a step-by-step process to add an Excel Web access part to the page and connect the workbook to the Web part.
Custom Attributes of Excel Web access web parts	Provides detailed information about unique properties of Excel Web access web parts

NoteBefore connecting a workbook to a Web part, you must publish the workbook to excel services or upload it to the Sharepoint Server 2010 document library. For more information, seeHow to publish a workbook?.

Back to Top

How to publish a workbook?

To publish a workbook to SharePoint Server 2010, you must first create a workbook in Excel. It can include Excel functions such as tables, charts, and pivot tables.

PromptExcel Services supports most Excel functions, but it supports some functions in slightly different ways. For more information about supported and unsupported features, see differences in using workbooks in Excel and Excel services.

The following table provides a list of articles that can help you publish a workbook to excel services.

Content	Description
Publish a workbook to excel services	This section describes how to publish a workbook and how to use parameters and named projects.
Use an Excel Workbook as a guide for publishing a "fact version"	Provides an end-to-end view for publishing workbooks, including configuration management settings.
Edit or delete a workbook in Excel services	Describes how to edit a published workbook.