Web part using Excel Services

Here I will explain how to develop a webpart using excel services in 10 easy steps.

1. Check Excel service is running or stopped. For this,
Open Central Admin -> Operations -> Services on Server, then Start the Excel Calculation Service on the server if it has been stopped.

2. Create a Document Library in your MOSS Site.
Go to Site Actions -> Create -> Document Library to create a document library in your SharePoint site. This document library will be useful to publish our Excel spreadsheets.

3. Trusted File Location
To do this, open the Shared Services Administration Site then click the Trusted File Locations -> Excel Services Settings. Now, click Add Trusted File Location and add our document library as a trusted location.

4. Now creating chart using excel.
Open excel file and enter some data as shown below.
Subject Marks
Maths 40
Science 50
Hindi 43
Computers 60

From Insert menu select Chart.
Select the entire table from subject to marks (table as prepared above).

5. Now from File - > Publish - > Excel Services
6. Select "Excel Services Option" button from "Save As" dialog box.
7. From "Excel Services Option" dialog select "Items in the workbook" from dropdownlist. Click on OK button.
8. Now navigate to your site. Now Site Actions - > Edit page.
9. Add "Excel Web Access Webpart" webpart. From Web part properties set the Workbook property as Shared document library path along with excel workbook name (eg: http://blahblah.com/sites/Shared Documents/TestChart.xlsx)
10. Click on Apply and then Ok button. That is.


Easy way of doing excel services in sharepoing.