Excel Services Interactive View introduces a new web based capability that extends Microsoft's Excel Services offering. This new capability provides a limited interactive view of any table in a web page.
Here we look at how it works for a single table on a web page. It requires two HTML tags. The first goes before the table and the 2nd goes just about anywhere that a script tag can be legally present.
A sample tag that goes before the table is below. The default values (see xx) will work just fine.
<a href="#" name="MicrosoftExcelButton" data-xl-tableTitle="" data-xl-buttonStyle="Standard" data-xl-fileName="Book1" data-xl-attribution="" ></a>
Before we go any further, a very important step to protect the design of a web page that contains the Interactive View capability. The default tag provided by Microsoft contains no information that is visible in design view! This makes it extremely easy to inadvertently delete the tag. So, at the very minimum, we will add text in the body of the anchor tag that is visible at design time.
<a href="#" name="MicrosoftExcelButton" data-xl-tableTitle="" data-xl-buttonStyle="Standard" data-xl-fileName="Book1" data-xl-attribution="" >Excel Interactive View</a>
The second HTML tag adds the necessary JavaScript code. It can go anywhere that JavaScript is legally allowed in the HTML document, though Microsoft recommends putting it just before the end of the document (before the /body tag).
<script type="text/javascript" src="http://r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1"></script>
| Rank | Nation | Gold | Silver | Bronze | Total |
|---|---|---|---|---|---|
| 1 | China (CHN) | 29 | 16 | 14 | 59 |
| 2 | United States (USA) | 27 | 14 | 15 | 56 |
| 3 | Great Britain (GBR) | 16 | 10 | 10 | 36 |
| 4 | South Korea (KOR) | 10 | 4 | 7 | 21 |
| 5 | France (FRA) | 8 | 7 | 9 | 24 |
| 6 | Germany (GER) | 5 | 10 | 6 | 21 |
| 7 | Italy (ITA) | 5 | 5 | 3 | 13 |
| 8 | Kazakhstan (KAZ) | 5 | 0 | 0 | 5 |
| 9 | North Korea (PRK) | 4 | 0 | 1 | 5 |
| 10 | Russia (RUS) | 3 | 16 | 14 | 33 |
Table 1 -- Top medal contenders as of August 5, 2012
(ranked by gold medal count)
