ExcelImporter
The Excel Importer creates a new message in CSV format for each tab of the Excel file. A message with the subject of the register name is created for each register in the Excel table.
- If the option “Create Header” or “Add Record Tag” is enabled, the “Header” or “Line” identifier is added to the first column as the identifier for the line.
- If the options “Generate Header” and “Add Record Tag” are switched off (=No) and the option “No Line Numbers” is active (=Yes), you will get a CSV format in the columns as they are in the Excel table
Note: This jobstep is part of a Modul subject to licence!
| Properties | |
|---|---|
| Name | Description |
| Stop when partner missing | Dont create a message if input message has no partner |
| Set state to | Specifies the state to receive the message when it is created. |
| Skipped rows | Comma separated list of the rows that should be skipped. First row starts at 1 |
| Seperator | Specifies the appropriate separator for separating the fields. Default is; . |
| Sender field row | Row number for sender field. First row starts at 1 |
| Sender field column | Column number for sender field. First column starts at 1 |
| Numeric format | The culture format the numeric values are written. E.g. de-DE, en, etc.. Default is the invariant culture a culture independent format.If the value is not set the culture settings of der server eBiss is running on is used. |
| Messagebox name | The Messagebox where the messages should be moved to |
| Move non-excel messages to output messages | Erroneous messages are moved to OutPutMessages. |
| No line numbers | To suppress the line numbers when creating the message. |
| Date/time format | The culture format the date and time values are written. E.g. de-DE, en, etc.. Default is the invariant culture a culture independent format. If the value is not set the culture settings of der server eBiss is running on is used. |
| Create header | Creates a header with filenames, timestamps, and a new line. |
| Character encoding | Specifies one of the following encoding: ASCII, UTF-8, ISO-8859-1, Unicode. |
| Add record tag | If active, a line with Seperator is attached for each line. |
| Worksheet | If specified, only the worksheet named in this way is converted |