According to Microsoft:

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.

By using Excel Interactive View (EIV) in SharePoint we can change the way that a table is presented.
From a regular table, using EIV we can convert it into a smart table, that can do different operations:

  • Sorting;
  • Filtering;
  • Add charts;
  • etc.

Excel Interactive View

 

More than that, this technology can be used in WordPress.
The Excel Mashup team has created a plugin for WordPress.
Here is a page where the EIV plugin is used: EIV
Of course, you can use the embed code, if you don’t wanna use the plugin.

Resources:

Note: The Romanian version of this article is posted here: Cum creăm tabele inteligente în SharePoint Online 2013?

How do we add EIV into SharePoint?

  • on the Excel Mashup website generate your code;

Excel Mashup

  • in SharePoint go into Edit Mode;

Edit Mode

  • from the Insert tab choose to insert a Content Editor web part;

Add Web Part

  • go into Edit mode for the web part and the click inside the web part;
  • create you table as you wish;
  • from the Format Text tab click on Edit Source;

Edit Source

  • copy the code generated on the Excel Mashup website – code from Step 1;

EIV Steps

  • paste the code above the table tag

Step 1

  • copy the code generated on the Excel Mashup website – code from Step 2;

EIV Steps

  • paste the code above the closing body tag;

Step 2

Note: because the SharePoint website uses https, you must change the second code.
Change only the source part: from http to https.
If you will not change it, every time the page loads, a security pop-up message will be displayed.

Step 2.1

Now, save the changes.

EIV 1

As seen above, the EIV button is displayed above the table.

If you click that button, the magic happens.

EIV 2

You can choose to open the workbook using Excel Web App to see what happens behind the scenes.

EIV 3

The workbook contains Slicers, a table and charts. All those elements combined gives us the Excel Interactive View technology.

=============================

Note: if you won’t use a web part, the second code will be removed, once you validate the changes.

Warning

Ți-a plăcut articolul?

Ți-a plăcut articolul?

Abonează-te pentru a primi direct în Inbox cele mai noi articole și tutoriale despre Windows sau Office și știri despre Microsoft. Newsletter-ul are și conținut exclusiv pentru abonați: recomandări de aplicații și gadget-uri, interviuri și alte resurse utile.

Abonarea a reușit !

Alex a absolvit Universitatea Politehnica din Bucureşti ca Inginer de Procese Speciale și și-a descoperit pasiunea pentru Microsoft Office încă timpul facultăţii. În tot mai puținul său timp liber Alex scrie pe site-ul ”Windows fără limite” diverse articole de tip Tips & Tricks pentru suita Microsoft Office, pentru Microsoft Windows, Windows Phone, Microsoft Office 365, etc.

Alte recomandări ...