XML to Excel

XML to Excel

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. Please note that the component also works with SPLF as input.

 

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:

    NG2XMLtoExcel0004


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.


    • Related Articles

    • EXCEL

      EXCEL is one of the file types, that can be handled as input in the workflow. Only input excel files in the format, .xlsx is supported. The excel files can e.g. be converted into xml with the component, Excel to XML.

    • XML Node Selection & Referencing

      XPath provides multiple ways to reference and navigate through an XML structure. Learn how to select specific nodes using direct references, index numbers, conditions, and relationships with other nodes. Connecting preceding or following node sets to ...

    • Excel to XML component

      The advanced, converter workflow component, Excel to XML converts an input excel file in the .xlsx format into the special XML format. The converter handles rows, columns and the most important styles. A related workflow component can create an ...

    • Excel designer

      Excel Support It is possible to generate Excel output in InterFormNG2, and it is also possible to convert Excel files into XML. You need however to have a license for InterFormNG2, that includes the Excel functionality, which can be support for ...

    • Excel templates

      Excel templates contains the setup of the Excel output based on an input file. The Excel templates are saved with other templates in the templates section of the Library. Templates can be organized by placing them in sub-directories in the Template ...