Excel Interactive View
Published: July 16, 2012
Excel Interactive View is a new technology, powered by Excel Services, that generates Excel table and chart views on-the-fly, in the browser, from an HTML table hosted on a web page. This topic provides a high-level introduction to the Excel Interactive View technology including a brief discussion on how it works.
Applies to: SharePoint Server 2013 | Excel Services (SharePoint 2010)
Excel Interactive View is a brand new technology introduced in Excel Services 2013. Excel Interactive View 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 web page. Using Excel Interactive View, users can harness the analytical power of Excel for use on any HTML table on any web page, in most browsers, without having Microsoft Excel installed.
To enable it, simply insert two HTML tags on your web page. The first tag that you need to insert into the HTML of the web page is a standard HTML <a> tag that has attributes that you can set to configure the Excel Interactive view.
<a href="#" name="MicrosoftExcelButton" data-xl-buttonStyle="Small" data-xl-tabletitle="My Table Title"></a> <table> <tr> … </table>
You insert the anchor tag above the HTML for the table that has the data that want to use to create an Excel Interactive View.
A typical anchor tag for the Excel Interactive View link button might look like the following anchor tag shown in Figure 1.
For more information about the Excel Interactive View attributes, see Excel Interactive View tag attributes later in this topic.
The second tag that you need to insert into the HTML of the web page is a standard HTML <script> tag that references the JavaScript file that creates the Excel Interactive View.
<script src="http://r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1" type="text/javascript"></script>
Important
|
|---|
|
If you add the tag to a site that uses the https protocol, change the src attribute to also use https, for example, .https://r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1 |
You should insert this tag at the end of the HTML for the page. The src attribute of this tag points to the required Excel Services JavaScript that does the work of creating the Excel Interactive View.
Additionally, you can change the language that the button uses by adding a locale parameter as part of the query string for the src attribute URL. The following <script> tag src attribute URL specifies German for the Excel Interactive View button language.
<script type="text/javascript" src="http://r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1&locale=de-de"></script>
When you browse the web page that has the Excel Interactive View tag in the HTML of the page, the tag renders as a clickable link button just above the table that you want to create an Excel view from. Users choose this link button to create the Excel Interactive view.
Once a user chooses the Excel Interactive View button, the view displays on top of the web page, as shown in Figure 2. Inside the Excel Interactive View, you have options to filter the view, configure options for the view, open the view in Excel Web App, or download the view as a workbook.
Figure 3 shows the options pane in the Excel Interactive View.
The following table lists the options that you can set for the Excel Interactive View.
|
Attribute |
Required? |
Default value |
Description |
|
data-xl-dataTableID |
No |
N/A |
Sets the unique identifier for the table. |
|
data-xl-buttonStyle |
No |
Standard |
Sets the button graphic style. You can choose between 2 styles:
|
|
data-xl-fileName |
No |
“Book1” |
Sets the name of the workbook that you can download by clicking Download in the Excel Interactive View |
|
data-xl-tableTitle |
No |
Same as the Web page title |
Sets the title for the table. The title can be up to 255 characters long. For small tables with a long title, the title could be too long to display and part of the title might be cut off. |
|
data-xl-attribution |
No |
"Data provided by [website domain]" |
Sets a message that you can use to describe the source for the view data. For example, "Data provided by Contoso.com." The message is visible within the workbook when you view the workbook in Excel Web App and when you download and view it in Microsoft Excel. The attribution can be up to 255 characters long. |
By simply adding two tags to a webpage, you can transform a static HTML table into a highly interactive Excel view that allows you to use the analytical power of Excel to gain insight into your data.
