1. Babelway
  2. Babelway User Guide
  3. Chapter 4. Manage & Build

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. 

 Headers 

 Select if first row contains field headers.