Excel
Table of Contents
 | Excel Workbook | This node provides access to the Microsoft Excel files. |
 | Excel Cell (Row,Column) | This node reads Excel cell data specified by a row and column index. |
| Excel Cell (Name) | This node reads Excel cell data specified by the cell name. |
 | Excel Range Array | This node reads a range of cells containing numbers and provides them as a float array. |
| Excel Custom Range | This node reads a range of cells and fills a user defined data structure. |
The Excel nodes provide read access to Microsoft´s Excel files up to the version of Office 2010.
Excel Workbook
The Excel Workbook node reads .xls and .xlsx files and provides the contained data to the other Excel nodes for reading. The input property File specifies the Excel file. If the AutoUpdate property is enabled Ventuz will reload and update the Excel data if the specific file was modified. This is an easy way to provide Ventuz scenes with new content. The ASync property makes it possible to load Excel files in a background process without disturbing the rendering. The output property Workbook has to be bound to one of the Cell or Range reader nodes to access a desired Excel cell or range of cells. SheetCount provides the number of sheets in the current Excel file. SheetName provides the name of the active workbook sheet.
Excel Cell (Row,Column)
This Cell node reads date and properties of a cell which has to be specified by the Row and Column index. The Sheet property specifies the index of the Excel sheet which should be read. The Workbook property receives the output of an Excel Workbook node.
Several output properties provide content and characteristics of the specified Excel cell. Foreground provides the text color used in the cell. Background provides the cell background color. The output property Text provides the string representation of the cell content. Comment provides a cell related comment if available. The property Number provides a floating point value if the content of the cell is a number. The same applies to DateTime. Font specifies which font is used in the cell.
Excel Cell (Name)
This Cell node reads date and properties of a cell specified by its Name. The Workbook property receives the output of an Excel Workbook node. If a cell with the specified name was found, the output properties IndexRow, IndexColumn and IndexSheet provide its location. The other output properties are the same as for the Excel Cell (Row,Column) node. A description can be found there.
Excel Range Array
This node reads a range of Excel cells with numeric values and provides them as a float array in the Output property. This makes it well suited for visualizing Excel data by a Chart node. The input properties have the following functionality: The Workbook property receives the output of an Excel Workbook node. The Sheet property specifies the index of the Excel sheet which should be read.
Properties in the Range category define the position and size of the interesting cell range. ReadDirection defines if the cells should be read in a row or in a column. Accordingly RangeIndex specifies the index of the row or column where cells should be read. RangeLength specifies the number of cells to read. CellOffset defines the offset to the first cell where reading should start in the according row or column.
The property NotANumber specifies how cases should be handled if a cell in a range does not contain a numeric value. Possible modes are:
| SetToZero | Value in the output array is set to zero. |
| SetToNotANumber | Value in the output array is set to NotANumber (NaN). |
| ReadNextCell | Reading proceeds to the next cell with a number. |
| StopReading | Reading is aborted. |
Excel Custom Range
This node fills a customizable structure with the values of a range of cells. The function of the input properties is the same as for the Excel Range Array node. The length of the range and the types of values to read is defined via the Custom Model Dialog. Currently the any number of the types float, string and DateTime can be added as output properties.