====== 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

{{:images:sign_warning.png?nolink|}}**Note:** This jobstep is part of a [[en:ueberblick:ebiss_module:start|Modul subject to licence]]!

^GENERATED src="ExcelImporter.Resources.Jobsteps.ExcelImporter" changed=""^^
^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|