Posted a question yesterday and got a great suggestion to use Excel REST. I've looked at the documentation but had a basic question about how to apply it.
I've got 3 workbooks in a document library on a 3rd party hosted Sharepoint Enterprise system (Sheet1.xlsx, Sheet2.xlsx, and Sheet3.xlsx). Each workbook has a Range of cells and a Chart that contain company performance data. I want to create a page that displays the 3 Ranges and 3 Charts. The page ("dashboard") will be for viewing only - i.e. the users who access the page do not need to interact with the data other than to view it.
Each workbook uses Data Validation and Sheet Protection, so using standard Excel Web Access will not work.
According to the documentation on Excel REST, the URL's I needto create are:
http:///_vti_bin/ExcelRest.aspx//Sheet1.xlsx/model/Charts('SampleChart1') http:///_vti_bin/ExcelRest.aspx//Sheet2.xlsx/model/Charts('SampleChart2') http:///_vti_bin/ExcelRest.aspx//Sheet3.xlsx/model/Charts('SampleChart3') http:///_vti_bin/ExcelRest.aspx//Sheet1.xlsx/model/Ranges('Rangename1') http:///_vti_bin/ExcelRest.aspx//Sheet2.xlsx/model/Ranges('Rangename2') http:///_vti_bin/ExcelRest.aspx//Sheet3.xlsx/model/Ranges('Rangename3')
How do I create a page in which these URL's are embedded and linked to the Workbooks stored in the Document Library? This may sound very basic, but I can't seem to figure it out.