Get data table Version 7 (Net)

Action group: XML


Description

The action extracts attribute values from all XML elements with the specified name found in the document and forms a table from them.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
XML-documentAn instance of the XML document.Robin.XMLXML contextYes
Name of XML-elementSpecify the name of the XML element from which to take attribute values for tableRobin.String
Yes
HeadingIf the value is «true», the table header will be inserted into the document along with its rows.Robin.BooleantrueNo
Remove duplicate headerIf the value is «true», indexes will be added to the same column names in the header of the resulting table. Numbering starts from 1.Robin.BooleantrueNo
Results
ResultThe resulting table. The column headers will be the names of the attributes of the XML elementRobin.DataTable

Special conditions of use

Gets a table of parameter values for elements with the specified tag.

In xml, the header string is assembled from the names of duplicate elements, which specify the cell values for each row of the table.

Example of use

Task

You have an XML-document. Create a table with the Cell attribute.


Solution

Use the "Load XML", "Get data table", "Table to CSV" actions.

Implementation

  1. Assemble a robot scheme with the actions: "Load XML", "Get data table", "Table to CSV".

  2. Set the "Load XML" action parameter.
  3. Set the "Get data table" action parameters.
  4. Set the "Table to CSV" action parameters.

Result

The program robot completed successfully. The data on the Cell element was extracted.

 


  • Нет меток