Configure XLS(X) Data Input

The Number of description rows setting defines a number of rows to ignore before the first row is extracted from the spreadsheet.

The Number of header rows setting affects the final structure of the generated XML file. It is used for determining if the first row(s) in the Excel spreadsheet should be parsed as column names and not as data. If the description rows are set to be ignored, they are not considered.

The number of defined rows to be considered as header rows.

The Sheet names for elements setting is designed to use a sheet name instead of the Sheet node and its Name attribute. To apply the setting, select the corresponding checkbox in the Form Options dialog.

When the setting is applied, it affects the input as follows:

The Header names for elements setting affects the final structure of the generated XML file, where a header name is used instead of the column name with attribute. To apply the setting, select the corresponding checkbox in the Form Options dialog.

As a result, the input looks as follows:

If you select the Include empty cells checkbox in the Form Options dialog to activate the setting, the XML data also include the cells with empty values, otherwise, they are ignored and not present in XML.