Connect your Digital Signage displays with Microsoft Excel to display live metrics and visualisations across organisations.
App main features
✔ Authenticate securely with Azure AD credentials
✔ Choose Your Excel file with ease using OneDrive file picker
✔ Your Excel application will display either your file’s Charts or Table data based on your settings
Secure authentication – choose your file from OneDrive App settings
✔ OneDrive file picker to choose your file
✔ Choose tab and set the data range
✔ Choose to show either the Charts in the file or the table data
✔ 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
Authorize using OAuth2 Authorization
OneDrive file picker is accessible after authentication. This allows you to choose the right file to display.
Need admin approval?
If you are prompted about needing admin approval read how to proceed from these articles:
Excel file
Choose your excel file.
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 ! 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.
SHOW ADVANCED
Update interval in hours. Min 1, max 24
How often Valotalive should fetch data from One Drive
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.
You might also be interested in this article: