Connect your Digital Signage displays with Microsoft Excel to display live metrics and visualisations across organisations.
App main features
✔ Secure authentication with Azure AD credentials
✔ Excel files are easy to pick with OneDrive file picker
✔ Show either Excel Charts or Table data on the displays based on your settings
✔ Set the tab and the data range
✔ Set the data update interval
M365 Excel - Activate and use
Easiest way for activating a content App is from Valotalive Dashboard. Just click the icon of the content you wish to activate and proceed. More detailed info of the first steps can be found here:
Settings on the Apps' Configuration tab
Theme:
The color palette from the file itself isn't provided to Valotalive.
However, the look & feel can be adjusted by choosing (or creating) a theme.
Font Color - Is applied according to the Theme’s body text font color
Tip: By embedding the Excel sheet /chart to a PowerPoint you can run contents with the chosen colors on displays.
Further read: How to activate Valotalive PowerPoint app
Authorize using OAuth2 Authorization
Need admin approval?
If you are prompted about needing admin approval read how to proceed from these articles:
Choose the Excel file
OneDrive file picker is accessible after authentication. This allows you to choose the right file to display.
What to visualize?
Show only celldata
Displays a scrolling view of the table. You can adjust the speed of the scroll with “Duration” - the duration of scrolling through the data once
Show only graphs
Choose this setting to display the graphs (the charts) in the particular file. The app automatically displays all graphs that can be found in the file.
Show both graph and celldata
Data range from the sheet
Enter the data range you want to use. Default setting is A1:Z24 selecting 24 rows from the columns A to Z in the first visible sheet.
Use A1 notation: [SheetName]![top left corner]:[bottom right corner]. Row numbers are mandatory. E.g. if you want to show contents on Sheet1 from cells A1:C10 type in Sheet1!A1:C10
IMPORTANT !
All letters for data range need to be in CAPITAL letters.
Make sure the name of the sheet in the settings matches with the name on your Excel sheet. E.g. If it says Tabelle1 instead of Sheet1 in your Sheet, you have to put Tabelle1!A1:C10 instead of Sheet1!A1:C10.
Cell border color TIP: If you have a light background (Theme settings) you should use darker color for cell borders
Duration
How many seconds should a post be visible.
Complete the work by adding the app to a flow or directly to a display.
The M365 Excel App will display the selected chart in its original size as an image and data updates are every 15 minutes.
You might also be interested in this article: