Excel
Code File Location: VisualSim\actor\lib\excel\Excel
Excel block takes an array of values of the same type and converts it into a .csv, .xls , .xlsx format. The parameter columnHeader in excel block defines the names of the column. The incoming array of data are placed in the respective column to match the heading. For the arrays, each index of the array becomes a separate row value and the columnHeader values become the column value.
The structure of all incoming data must be identical.
Excel
demo
model
| Parameter |
Explanation | Type |
| fileOrUrl | The
format is file://C:/VisualSim/filename.txt
(Windows) or file://VisualSim/filename.txt (Unix/Linux). The filename can be a concatenation of any number of individual strings and parameters, separated by "+". This can be used to name the output files differently for each simulation run during batch mode operation. |
String |
| columnHeader | The parameter contains the column of each array value . The format should be {"ColumnName1","ColumnName2","ColumnName3"} . | StringArray |
| Port | Explanation | Type |
| input | Input
accepts an array of data . |
General |