The advanced, create document workflow component, XML to Excel is described below. This is a workflow component, that accepts a special formatted input XML file (that defines the Excel layout) and converts this into an Excel file in the payload. After this you can consider e.g. to save the payload to a file with the component, To filesystem.
This component should not be confused with the workflow component, Create Excel document, which is used a lot more.
The input XML file, which must be loaded into the payload prior to this component must have a layout as described in the section, Internal Excel format. Such an XML file can be created from an XLSX file with the component, Excel to XML.
The XML to Excel component has this parameter:
Existing XLSX document
This is an optional parameter. You can refer to an existing XLSX file. You can even use an XPath expression to select a dynamic file, if you click on this image on the right:
If you state an XLSX document, then the data of the input XML file will be inserted as data into the referenced XLSX file - provided that the data in the XML file is formatted like described in the section, Internal Excel format.
