Viz Multichannel User Guide
Version 4.2 | Published July 31, 2023 ©
Importing from Excel
The Excel module supports both *.xls and *.xlsx formats.
The Excel sheet column is your Reference in the mapping table. For example, for column A set $A, and so on.
When working with Excel files, the first row should always be the header row, which must span all columns in use. The Header Lines Included option must also be checked.
Enter $ and the letter representing the sequential column. You can call multiple columns/elements in a chain. You can also add characters to separate them. For example: $A / $G / $X
You can also take a portion of the column with the following notation: &(COLUMN,”DELIMITER”,FROM,COUNT). If the delimiter is empty, it will split into characters. For example, if L is 31.12.2006.
&(L,””,1,2) => "31" &(L,””,11,2) => "" &(L,””,10,2) => "6" &(L,”.”,1,2) => "31.12" &(L,”.”,2,2) => "12.2006" &(L,”.”,2,3) => "12.2006" &(L,”.”,4,1) => "" &(L,”.”,3,2) => "2006" &(L,”/”,2,1) => "" &(L,”/”,1,1) => "31.12.2006"Secondary Fields in Excel
Data can be added to the schedule file that can be used by Viz Multichannel to fill pages with data. In order to achieve this you need to add in additional columns after the other columns in the Excel sheet.
If you are using column headers you also need to define column headers for the additional columns (for example field1, field2, and so on).
Viz Multichannel will start reading the fields, one by one, from that column until it gets to the first empty column header.
IMPORTANT! To use the Excel Import Type you must install Microsoft® Excel on the machine that imports the schedule file.
Note: There is a limitation of 100 columns when importing from Excel files.