Suppose that you have published an Excel workbook to a SharePoint library, and now you want to display all or part of that workbook in its own SharePoint Web Part. You can do this by using a special Web Part known as the Excel Web Access Web Part.
Create Excel Services Application. LINK
Manage Excel Services trusted file locations. LINK
Create excel document with chart or table.
Save to SharePoint library.
In Browser View Options check chart.
Edit page.
Insert, Web Part. From the Categories menu, select Business Data.
From the Parts menu, select Excel Web Access and click add button.
Click here to open the tool pane.
Click the button under Workbook and choose excel file.
In the Named Item textbook, enter the name of chart or table.
Ok, Save Page.
That's it!
Web part is automatically synchronizes with excel file.
Create Excel Services Application. LINK
Manage Excel Services trusted file locations. LINK
Create excel document with chart or table.
Save to SharePoint library.
In Browser View Options check chart.
Edit page.
Insert, Web Part. From the Categories menu, select Business Data.
From the Parts menu, select Excel Web Access and click add button.
Click here to open the tool pane.
Click the button under Workbook and choose excel file.
In the Named Item textbook, enter the name of chart or table.
Ok, Save Page.
That's it!
Web part is automatically synchronizes with excel file.
No comments:
Post a Comment