Excel Web Access Web parts expose data in an Excel
spreadsheet in SharePoint. To
create an Excel Web Access Web part in SharePoint2010, follow these steps:
1. Open Microsoft
Excel. Click File ➪ New ➪ Blank Workbook
2. Add some data in the spreadsheet, and then
create a simple chart using the
native chart
capabilities.
To do
this, select the data from which you want to create a chart, and then
select Insert.
Then select a particular chart type.
Following snapshot shows the Pie chart graphically representing
the data.
 |
ExcelSheet to be displayed in SharePoint 2010 web part |
3. Save the Excel document to a document library on your
SharePoint site.
4. Once saved, right-click
the document in document library and select “Edit in Microsoft Excel”
5. Click Publish ➪ Excel Services.
6. When
the Save As dialog prompts you, click the ‘Excel Services Options’
button, and then
select the parts of the workbook you want to publish to Excel Services.
In this example,
we will only expose the chart.
7. Save the Excel
document. Navigate to a separate SharePoint site or Web
page, and click
Site Actions ➪ Edit Page.
8. Click “Add a web
part” (or Insert ➪ web part), and then navigate to the Office Client Applications category.
9. Select
Excel Web Access and click Add (If you do not find ‘Excel Web
Access template’
there then navigate to Business Data).
10. SharePoint adds the Web part, but you still must
configure it. Open the tools pane and enter the URL to the spreadsheet in the
Workbook field (or navigate to the spreadsheet). Enter the object you want to
expose in the Excel Web Access Web part (In our case Chart 1).
Finally
the ‘Excel Web Access’ web part is displayed with excel data as in following
snapshot.
 |
‘Excel
Web Access Web Part’ displaying Excel sheet data. |