Page Operations
Browse SpaceDescription
The Excel Output step allows you to write data to one or more Excel files. The following sections describe the features available for configuring the Excel output step.
File Tab
The file tab is where you configure the filename of the Excel output step. Available options include:
| Option | Description |
|---|---|
| Step name | Name of the step; this name has to be unique in a single transformation |
| Filename | This field specifies the file name and location of the output text file |
| Extension | Adds a period and the extension to the end of the file name (.xml) |
| Include stepnr in filename | If you run the step in multiple copies (see also Launching Several copies of a step, the copy number is included in the file name, before the extension (_0). |
| Include date in filename | Includes the system date in the file name (_20041231). |
| Include time in filename | Includes the system time in the file name (_235959). |
| Show filename(s) | This option displays a list of the files the will be generated.
|
Content
The content tab provides additional options for the generated Excel output file including:
| Option | Description |
|---|---|
| Header | Enable if the spreadsheet needs a header above the exported rows of data |
| Footer | Enable if the spreadsheet needs a footer below the exported rows of data |
| Encoding | Specifies the encoding of the spreadsheet, leave empty to keep the default for the platform |
| Split every...rows | Splits the data over several output files. (each in its own spreadsheet) |
| Sheet name | Specifies the name of the sheet to which data is written |
| Protect sheet? | Enables password protection on the target sheet |
| Password | Specifies the password for the protected sheet |
| Use Template | This is an experimental feature that requires testing; enable to use a template when outputting data to Excel |
| Excel | The name of the template used to format the |
| Template | Excel output file |
| Append to Excel template | Enable to have the output appended to the Excel template specified |
Fields
The fields tab is where you specify the Name, data type, and format of the fields being written to Excel. Get Fields retrieves a list of available fields from the input stream(s) coming into the step. Minimum Width changes the options in the fields tab automatically so that the resulting width of lines in the text file is minimal. So instead of save 0000001, "1" is written. String fields are not padded to their specified length.
Note: You can specify any format definitions available in Excel. These formats are not tied to any Kettle specific formatting.
can we fetch more specific information about the setting of the Filename,especially contain the location of the output text file, 'cause when i run on the server , the excel will be located on the tomcat/bin folder defaultlly with only the filename given !