What Is a View?
A view controls what part of your Excel file appears on the Valotalive display. You can show a full sheet, a specific cell range, or combine several sheets into one screen. Each line you enter in the Views field creates one view.
đĄ Tip: Leave the Views field empty to automatically show every sheet in your file - one view per sheet. |
How to Add a View
1. Open the Excel Table Data App configurations on the left side tab.
2. Locate the Views field.
3. Enter one view per line, using the syntax in the table below.
4. Click Save.
View Syntax Reference
Syntax | What it shows | Example |
Sheet1 | Show the entire sheet | Sheet1 |
Sheet1!A1:H20 | Show a specific cell range | Sheet1!A1:H20 |
Sheet1!A:D | Show entire columns | Sheet1!A:D |
Sheet1!A1: | Show from a starting cell to the end of the sheet | Sheet1!A1: |
View1 + View2 | Combine two or more sheets or ranges into one screen | Sheet1!A1:H20 + Sheet2!A1:D9 |
Keyword* | Show every sheet whose name starts with the keyword | LINE* |
* | Show every sheet in the file | * |
#2 | Show a sheet by its position, regardless of its name | #2 |
Heading | View | Add a title above the view on screen | Week plan | Sheet1!A1:H20 |
(empty field) | Show every sheet automatically, one view per sheet |
|
Common Examples
⢠Growing sheet: Use Sheet1!A1: to always include new rows as your data grows, without updating the range.
⢠Multiple KPI sheets on one screen: Combine ranges with +, e.g. Safety!A1:D20 + Quality!A1:D20.
⢠Multiple similar sheets: Use a wildcard like LINE* to show every sheet whose name starts with "LINE," without listing each one.
⢠Sheet name changes monthly: Use #2 to always show the second sheet in the file, regardless of its name.
Tips
⢠Sheet names are case-sensitive, enter them exactly as they appear in Excel.
⢠Add as many views as you need, one per line.
⢠Add a heading to each view so it's easy to identify what it shows on screen.
⢠Sheet names with spaces don't need quotes, enter them exactly as they appear.