Excel App main features
✔ Secure Authentication: Use your Entra ID credentials (formerly Azure AD) for secure access.
✔ Flexible Visualization: Choose to display either Excel Charts or Table data based on your settings.
✔ Specify Data: Set the exact tab and data range you want to show.
✔ Control Updates: Define how often your data refreshes with the data update interval.
The Valotalive Excel app also offers enhanced customization and data analysis tools:
Conditional Formatting: Define rules to format cells based on their values, revealing data trends and patterns (e.g., color-coding temperature figures).
Fill Color: Easily change the background color of cells, rows, or columns to organize data visually.
Color Scales: Apply gradient colors to a range of cells, visually representing data distribution.
Table Format: Quickly convert cell ranges into professionally styled Excel Tables with built-in filtering and sorting.
Font Color: Customize the color of text within cells.
Border Color: Change the color of cell borders to distinguish and organize your data.
Cell Style: Apply predefined collections of formatting characteristics for consistent visual presentation.
M365 Excel - Activate and use
Getting Started
The easiest way to activate the M365 Excel content App is from Valotalive Dashboard Simply click the app's icon and follow the prompts. For more detailed initial steps, refer to the Valotalive content App - Activate and go live guide.
App Configuration Settings
Theme
Your selected Theme determines the background color, while all other colors are sourced from the original file.
Authorize using OAuth2 Authorization
Need admin approval?
If you are prompted about needing admin approval read how to proceed from these articles:
Choose Your Excel File
After authentication, the file picker will appear, allowing you to select the Excel file you wish to display.
What to Visualize?
Show only celldata: Displays a scrolling view of your table data. Adjust the scroll speed using the "Duration" setting, which controls how long it takes to scroll through the data once.
Show only graphs: This setting will automatically display all charts found within your Excel file.
Show both graph and celldata: Displays both charts and table data.
Data range from the sheet
Specify the data range you want to use. The default is A1:Z24, selecting 24 rows from columns A to Z in the first visible sheet.
Use A1 notation:
[SheetName]![top left corner]:[bottom right corner]. Row numbers are mandatory. For example, to show content from cells A1 to C10 on "Sheet1," typeSheet1!A1:C10.Important!
All letters for the data range must be in CAPITAL letters.
Ensure the sheet name in the settings exactly matches the name in your Excel sheet (e.g., if your sheet is named "Tabelle1," use
Tabelle1!A1:C10instead ofSheet1!A1:C10).
Cell Border Color Tip: If you have a light background set in your Theme, use a darker color for cell borders for better visibility.
Duration
Set how many seconds a post should be visible.
Final Steps
Complete the setup by adding the app to a flow or directly to a display.
The M365 Excel App will display the selected chart at its original size as an image, and data updates occur every 15 minutes.
You might also be interested in this article: