It allows you to adjust the meta data of the ExampleSet created from the specified Excel file. data_set_meta_data_informationThis option is an important one.
#Mac excel text import wizard for mac
To parse an excel date afterwards use 'date_parse(86400000 * (parse(date_attribute) - 25569))' (- 24107 for Mac Excel 2007) in the Generate Attributes operator. Every column will be read as a polynominal attribute.
For example a value '32-March' will automatically be converted to '1-April'. Some corrections are automatically made in the date type values. If text in an Excel file column matches this date format, that column is automatically converted to date type. Many predefined options exist users can also specify a new format. date_formatThe date and time format is specified here.If you want to ignore any rows you can annotate them as Comment. If row 0 is assigned Name annotation, it is equivalent to setting the first row as names parameter to true. Name, Comment and Unit annotations can be assigned. This menu allows you to select any row and assign an annotation to it. annotationsIf the first row as names parameter is not set to true, annotations can be added using the 'Edit List' button of this parameter which opens a new menu.Then the attributes are automatically named and the first line of Excel file is not treated as a data line. first_row_as_namesIf this option is set to true, it is assumed that the first line of the Excel file has the names of attributes.'A1:E10' will select all cells of the first five columns from row 1 to 10. It is specified in 'xm:yn' format where 'x' is the column of the first cell of range, 'm' is the row of the first cell of range, 'y' is the column of the last cell of range, 'n' is the row of the last cell of range. The range of cells to be imported from the specified sheet is given here. imported_cell_rangeThis is a mandatory parameter.sheet_nameThe name of the sheet which you want to import should be specified here.sheet_numberThe number of the sheet which you want to import should be specified here.sheet_selectionThis option allows you to change the sheet selection between sheet number and sheet name.It can be selected using the choose a file button. excel_fileThe path of the Excel file is specified here.This user-friendly wizard makes the use of this operator easy. import_configuration_wizardThis option allows you to configure this operator by means of a wizard.This output is similar to the output of the Retrieve operator. This port delivers the Excel file in tabular form along with the meta data. InputĪn Excel file is expected as a file object which can be created with other operators with file output ports like the Read File operator. Please make sure that the Excel file is read correctly before building a process using it. The best way, which may require some extra effort, is to first set all the parameters in the Parameters panel and then use the wizard. The easiest and shortest way to import an Excel file is to use the import configuration wizard from the Parameters panel. Missing data values in Excel should be indicated by empty cells or by cells containing only "?".įor complete understanding of this operator read the parameters section. The data table can be placed anywhere on the sheet and can contain arbitrary formatting instructions, empty rows and empty columns. Please note that the first row of the Excel sheet might be used for attribute names which can be indicated by a parameter. The table must have a format such that each row is an example and each column represents an attribute. The user has to define which of the spreadsheets in the workbook should be used as data table. This operator is able to read data from Excel 95, 97, 2000, XP, and 2003. This operator can be used to load data from Microsoft Excel spreadsheets. SynopsisThis operator reads an ExampleSet from the specified Excel file.
0 kommentar(er)
