MS Office Excel Services provides a very powerful feature that allows you to add a very small number of JS references to the page, allowing you to convert the contents of the table into Excel charts on the page. way to present. Here is MSDN's introduction to the Excel Interactive View function:
Excel Interactive View is a new technology. It is a powerful service provided by Excel Services, which can instantly generate an Excel view from the HTML table on the page, and At the same time, some page interactive functions are provided.
Here is the MSDN address: http://msdn.microsoft.com/library/office/jj163261(v=office.15)
Without further ado, let’s take a look at the actual effect first !
Rank | Movie | Wknd | Gross | Wks |
1 | The Hunger Games | .6M | 8M | 2 |
2 | Wrath of the Titans | .50M | .50M | 1 |
3 | Mirror Mirror | .1M | .1M | 1 |
4 | 21 Jump Street | .8M | .9M | 3 |
5 | Dr. Seuss' The Lorax | .78M | 9M | 5 |
6 | John Carter | .03M | .2M | 4 |
7 | Salmon Fishing in the Yemen | .27M | .17M | 4 |
8 | Act of Valor | M | .7M | 6 |
9 | A Thousand Words | $.903M | .5M | 4 |
10 | Journey 2 | $.810M | .4M | 8 |
Box office data supplied by and copyright Exhibitor Relations © 2012 |
Usage is very simple, just two steps are enough!
1. Copy the following code before the table where you want to add Excel Interactive View. Note that in the HTML source code, copy it directly to the front of the table.
<a href="#" name="MicrosoftExcelButton" data-xl-tableTitle="" data-xl-buttonStyle="Standard" data-xl-fileName="Book1" data-xl-attribution="" ></a>
2. Add the following JS reference before
. It turns out that it doesn't have to be before , any valid position can be used.
<script type="text/javascript" src="http://r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1"></script>
Children who want to display Excel front-end effects are now in luck! !