Viz Multichannel
Version 4.1 | Published May 27, 2019 ©
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 your header row, and needs to span all columns in use. Also, the Header Lines Included option must 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 (e.g. 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 need to install Microsoft® Excel on the machines that imports the schedule file.
Note: When importing from Excel files, there is a limitation of 100 columns.