4.3.4.6. Excel

File sample

Below is a sample Excel file having headers at the first row of the Excel sheet.

Excel Sample file

 

The following properties are available:

Excel version (only available for Excel In)	Which Excel format is used (XLS or XLSX).
Ignore empty lines (only available for Excel In)	Check this to ignore empty lines.
Trim (only available for Excel In)	Check this to remove all spaces from text except for single spaces between words.
Dateformats (only available for Excel In)	Used date format.
SheetMode (only available for Excel In)	Single/Multiple sheets? If not selected, only the first sheet of the workbook is considered.
ExcelTemplate (only available for Excel Out)	The template is used to keep the template cells style of the newly generated excel for the first sheet. So for example if in the template first sheet the first cell is formatted as a date, the newly generated excel will also keep the same format for the same cell.
Remove empty sheets (only available for Excel Out)	If selected, and if you are using a template, Babelway will remove all the sheets after the last one that has been modified from the message out. For example if your templates has 3 sheets and during the transformation only the first two sheets are filled in, the file xlsx will have only 2 sheets.
Headers	Select if first row contains field headers.

 

N.B.: When generating an Excel file in the message definition out, Babelway automatically recognizes integer, double and date using the following formats by default: "dd/MM/yyyy", "dd-MMM-yyyy", "dd/MM/yyyy HH:mm:ss.SSS" provided that no template exists.