Transformer – Excel / XML Processor

The Transformer – Excel / XML Processor transforms Excel to XML and the reverse XML to Excel Format.

Select the Processor Configuration tab and click on Add Processor.

Select the Transformer – Excel / XML Processor from the drop-down.

On the Basic tab, you can specify:

Transformation: the transformation direction indicating if this transformer converts to or from XML

XML Encoding Type: specifies the XML character encoding

Password protected: specifies if the file is password protected

Password: File password

On the Conditional Execution tab, you can specify:

Execute Processor: Transaction data-dependent condition may be specified here as an enhanced expression. If this expression returns anything other than TRUE (ignore case) – this processor will be skipped

Execute Transformation: Transaction data-dependent condition may be specified here as an enhanced expression. If this expression returns anything other than TRUE (ignore case) – this transform will be skipped

On the XML to Excel tab, you can specify:

Add Header: specifies whether or not a header is expected.

Excel File Format: the version of Excel to transform to or from.