Synopsis
This operator reads an example set from Excel spreadsheet files.
Description
This operator can be used to load data from Microsoft Excel spreadsheets. This operator is able to reads data from Excel 95, 97, 2000, XP, and 2003. The user has to define which of the spreadsheets in the workbook should be used as data table. The table must have a format so that each line is an example and each column represents an attribute. Please note that the first line might be used for attribute names which can be indicated by a parameter.
The data table can be placed anywhere on the sheet and is allowed to contain arbitrary formatting instructions, empty rows, and empty columns. Missing data values are indicated by empty cells or by cells containing only "?".
Input
Output
- output:
Parameters
- configure operator: Configure this operator by means of a Wizard.
- excel file: Name of the excel file to read the data from.
- sheet number: The number of the sheet which should be imported.
- row offset: The number of rows to skip at top of sheet as they contain no usable data.
- column offset: The number of columns to skip at left side of sheet as they contain no usable data.
- first row as names: Indicates if the first row should be used for the attribute names.
- annotations: Maps row numbers to annotation names.
- read not matching values as missings: Values which does not match to the specified value typed are considered as missings.
- data set meta data information: The meta data information
- attribute names already defined: the parameter describes whether the attribute names were set by the user manually or were generated by the the reader (generic names or first row of the file)