The Properties dialog allows editing the elements in the Output:

 

1. Xml Output Properties

 

 

You can edit the name, namespace prefix and namespace URI for each element and attribute through this interface.

 

Note:

To map a field to a text string inside an XML element rather than a single attribute, enter "text()" in the Name box.

 

2. Excel Output Properties

 

Workseet Properties:

 

You can edit the worksheet name.

 

 

Row Properties:

 

You can edit the starting row index in Excel spreadsheet.

 

 

Cell Properties:

 

You can edit the starting cell index, data type and formulas.

 

Formulas use Excel specific syntax, for example CONCATENATE(RC[-1], RC[-2]) will concatenate the previous 2 cells in the same row.