Write Excel
Synopsis
This operator writes ExampleSets to an Excel spreadsheet file.
Description
The Write Excel operator can be used for writing ExampleSets into a Microsoft Excel spreadsheet file. This operator creates Excel files that are readable by Excel 95, 97, 2000, XP, 2003 and newer versions. Missing data values in the ExampleSet are indicated by empty cells in the Excel file. The first row of the resultant Excel file has the names of attributes of the input ExampleSet. Files written by the Write Excel operator can be loaded in RapidMiner using the Read Excel operator. Multiple input ExampleSets can be specified and this will lead to one excel file with multiple sheets. By default the sheets will be named after their corresponding ExampleSet's source. Sheet names can optionally be specified using the sheet names parameter.
Input
input
This input port expects an ExampleSet or a Collection of ExampleSets. The specified ExampleSets will become sheets in the resulting Excel file. The Write Excel operator can have multiple inputs. When one input is connected, another input port becomes available which is ready to accept another input (if any). The order of inputs remains the same in the resulting Excel file.
Output
file
The created Excel file is provided as a file object that can be used with other operators with file input ports like 'Write File'.
through
The ExampleSet or collection of ExampleSets that was provided at the corresponding input port is delivered through this output port without any modifications. This is usually used to reuse the same ExampleSets in further operators of the process.
Parameters
Excel file
The path of the Excel file is specified here. It can be selected using the choose a file button.
File format
Allows the user to specify if the resulting excel sheet should have the xls or xlsx format.
Sheet names
Sheets names can optionally be specified here. The first sheets name specified corresponds to the first input and so on. Sheet names that have not been specified will default to the name of their ExampleSet's source.
Compatibility level below 9.3.0: The first sheet name will be taken from the sheet name parameter. Additional sheet names can be specified here as described above.
Sheet name
The user can specify the name of the first excel sheet here. This parameter will only be shown for xlsx file format. This parameter is outdated and has been removed for versions starting from 9.3.0.
Date format
This is an expert parameter. Furthermore it is shown with file format xlsx only. Format dates should be saved in.
Number format
This is an expert parameter. Furthermore it is shown with file format xlsx only. Format number should be saved in.
Encoding
This is an expert parameter. Furthermore it is shown with file format xls only. There are different options. Users can choose any of them.