Vision Services Integration in Share Point 2010

2012-05-29T11:40:00.000-07:00

Go to Central Administrator -> System Settings -> Manage Services on Server

Manage Services on Server

We have to start Visio Graphics Service.

Visio Graphics Service

Go to the site url and create New Site from “Site Actions”

Now from Application Management -> Service Application -> Manage Service Application start Visio Service

Create application pool

Make Web drawing by saving image as .VDW

Upload .VDW file in Shared Document in subsite

Now create your site page and add Visio web Access web part

Assign web drawing url from shared document.

Finally you can see web diagram in web part in your site page.

Integrating Excel Data with an Excel Web Access Web Part

2012-05-29T11:03:00.000-07:00

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.

Excel and Visio Web Access Web Parts in SharePoint 2010

Vision Services Integration in Share Point 2010

Integrating Excel Data with an Excel Web Access Web Part