In this article we will be seeing how to access the Charts and PivotTable using REST URL and how to add the chart to the SharePoint Wiki page. Here is Part 1 Chart in the excel workbook:
Charts: In this section we will be seeing how to access the charts using the REST URL. REST URL: http://serverName:1111/sites/VJTesting/_vti_bin/excelrest.aspx/Shared%20Documents/ExcelChart.xlsx/model/Charts REST aspx Page URI - http://servername:1111/sites/VJTesting/_vti_bin/excelrest.aspx Workbook Location - /Shared%20Documents/ExcelChart.xlsx Resource Location- /model/Charts This will show all the charts available as shown in the following
http://ctsinmbpmoss:1111/sites/VJTesting/_vti_bin/excelrest.aspx/Shared%20Documents/ExcelChart.xlsx/model/Charts('Chart%201') Add the Chart to the SharePoint Wiki Page:
Pivot table in the excel workbook: Pivot Tables: In this section we will be seeing how to access the pivot tables using the REST URL. REST URL: http://serverName:1111/sites/VJTesting/_vti_bin/excelrest.aspx/Shared%20Documents/ExcelChart.xlsx/model/ PivotTables REST aspx Page URI - http://servername:1111/sites/VJTesting/_vti_bin/excelrest.aspx Workbook Location - /Shared%20Documents/ExcelChart.xlsx Resource Location- /model /PivotTables This will show all the pivot tables available as shown in the following
http://ctsinmbpmoss:1111/sites/VJTesting/_vti_bin/excelrest.aspx/Shared%20Documents/ExcelChart.xlsx/model/PivotTables('PivotTable2') The output looks like the following
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: