Portlet Factory, Version 6.1.2
XML element handling
When export data is taken from an indirect reference, that reference must provide XML that is structured as an HTML table. This table structure allows the builder to transform rows and columns in the XML into corresponding rows and columns in the exported Excel spreadsheet. A table structure might not be achievable for all indirect references. The Table Element Names input is provided so that table-like elements in the XML can be named and handled correctly by the builder.
You use this input to provide a comma-delimited list of XML element names that should be treated as table-like structures. Before performing an export, the builder will look for the named elements and convert them into HTML tables.
Note: The builder will look only at the root element of the XML provided by the indirect reference. If the root element does not have a recognized element name, then the XML is exported as-is.
In addition, the root XML element must have a table-like structure. That means it must contain "row" elements that aggregate "column" elements. If this structure is not present, the conversion and export will produce unpredictable results.
For convenience, the input contains several names by default. These names identify to the root XML elements used by various data integration builders. Therefore, if a data integration builder provides the indirect reference specified as the Source Reference input, then the data obtained from this reference should be exportable without needing to specify additional names for the Table Element Names input.
Parent topic: Excel Export builder
Library | Support |