Example

From the Project Explorer, under the Distribute section, select XML Designer. From the menu, select File, Open Template… and open the workbook Water Distribution.xlsx located in the Input folder of the project.

The XML structure is usually designed with an understanding of how the worksheet content will appear in XML. In our example, we will use the singular values such as the week number in $F$4 and the tabular Tank Level values for each well starting in row 21.

In the left pane, highlight the root element XML and click Modify. The root node supports comments.

With the root element highlighted click Add

This will create a child element of the root.

Select the Distribution element and click Add

Select Distribution Date element, click Add

Select Date element, click Add

At this point select File, Save from the menu to see the structure of the XML file with the cell references selected.

When the XML is produced, the cell references will be replaced by the values of the report.

We now turn our attention to the tank levels. We will arrange this information in the XML by creating an element for each well and setting child elements to represent the data.

Highlight Distribution Date in the left pane, click Add

The rule is configured to a range of cells which are tested to be non-blank. For a non-blank cell, all of its children are sent to the XML output adjusted by the row of the non-blank cell.

Configure the 4 child elements Day, Max, Min, and Avg

For the Value use {Template!$B$21}, {Template!$D$21}, {Template!$E$21} and {Template!$F$21}.

We will repeat for the configuration of Well 2 and Well 3 elements in a similar fashion to Well 1.

Highlight Well 1

The XML file can be generated manually from the designer.

Select the menu option Generate XML. This opens a dialog for a report name.

This will display the XML file generated. The XML file will be in the same folder as the report.