XML Source

Import XML data in a spreadsheet.

The XML Source feature allows to import data from arbitrarily structured XML content into cells in an existing spreadsheet document. It allows XML content to be imported either partially or in full, depending on the structure of the XML content and the map definitions that the user defines. The user can specify multiple non-overlapping sub-structures to be mapped to different cell positions within the same document. The user can import either element contents, attribute values or both.

XML Source Dialog

The dialog consists of four parts.

Source file

This lets you specify the path to the XML file that you wish to import into your document.

Map to Document

This pane shows the structure of the source XML content as a tree. This is initially empty, and gets populated when you specify the source file.

Cada elemento na árvore pode ser de um dos seguintes tipos:

• atributo, representado pelo símbolo @

• elemento simples, não recorrente, representado pelo símbolo </> e

• elemento recorrente, representado pelo símbolo <//>.

Um elemento não recorrente é aquele que apenas pode ocorrer uma única vez na árvore. Este elemento é mapeado em apenas uma célula do documento.

A recurring element is an element that can appear multiple times under the same parent. It serves as an enclosing parent of a single record entry of multiple record entries. These entries are imported into a range those height equals the number of entries plus one additional header row.

Célula mapeada

This field specifies the position of a cell in the document that an element or an attribute is linked to. If it is a non-recurring element or an attribute, it simply points to the cell where the value of the linked element/attribute will get imported. If it is a recurring element, it points to the top-left cell of the range where the whole record entries plus header will get imported.

Importar

Premir o botão Importar inicia o processo com base nas definições indicadas pelo utilizador. A caixa de diálogo fecha ao terminar a importação.