Databases Reference
In-Depth Information
The same concept works for anything that can traverse a URL and bring back data from it, includ-
ing applications such as Microsoft Word, Microsoft InfoPath, or PowerPoint. Have you ever wondered
how to get the Excel chart into a PowerPoint deck and have it refresh dynamically without having to
copy the file or embed the full file into PowerPoint? REST is the answer. Leave the file in SharePoint,
insert an image into PowerPoint, and then, in PowerPoint, specify that the image is from a Link, pro-
vide the REST URL to the chart, and enjoy an image that is refreshed every time the PowerPoint file is
opened.
excel Interactive View
Excel Interactive View is a technology that uses HTML, JavaScript, and Excel Services to generate Excel
table and chart views on the fly, in the browser, from an HTML table hosted on a webpage. It's a new
feature introduced in Excel Services 2013. Using Excel Interactive View, you can take advantage of
Excel on any HTML table, on any webpage, in most browsers, without having the Excel client installed.
For instance, Figure 6-27 shows a simple HTML table on a webpage.
FIGURE 6-27
A simple HTML table.
It's very simple. To use it, you just need to insert two HTML tags on your webpage. The first tag
that you need to insert is a standard HTML <a> tag, which has attributes that you can set to configure
the Excel Interactive view.
<a href="#" name="MicrosoftExcelButton" data-xl-tableTitle="My interactive view" data-xl-
buttonStyle="Standard" data-xl-fileName="Book1" data-xl-attribution="Data provided by My
Dashboard" ></a>
Just insert the tag above the HTML for the table that has the data that you want to use to create
an Excel Interactive View.
The second tag that you need to insert into the HTML of the webpage is a standard HTML <script>
tag, which references the JavaScript file that creates the Excel Interactive View.
<script type="text/javascript" src="http://r.office.microsoft.com/r/
rlidExcelButton?v=1&kip=1"></script>
Adding the two HTML tags to the page hosting the table from Figure 6-27 adds a bottom that
enables the Excel Interactive View, as shown in Figure 6-28.
Search WWH ::
Custom Search