Copy as Structured Text

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  User Guide and Reference > Menu Commands > Edit Menu >

Copy as Structured Text

The Copy as Structured Text command copies elements to the clipboard as they appear on screen. This command is especially useful for copying table-like data from the Table View of Grid View into another application that holds data in tabular form (such as a spreadsheet application).

 

Copying individual rows from Table View
Copying a whole table from Table View
Copying from standard Grid View

 

Copying individual rows from Table View

In the screenshot below two rows in the Table View of Grid View are copied as structured text.

view_table

The next two screenshots below show the data that was copied as structured text in the Grid View screenshot shown above now pasted in a Microsoft Excel document and in a Notepad document.

view_excel

Notice that while Excel (screenshot above) automatically formats each piece of cell text on the basis of its lexical form of text, Notepad (screenshot below) pastes all cell text as strings.

view_notepad

 

Copying a whole table from Table View

In the screenshot below, a whole table is selected (by clicking the item (6) node entry).

view_table01

The result is as for individual rows above, except that the table's column titles are now also copied. The screenshot below shows the copied data pasted into a Microsoft Excel worksheet. Note that, in the XML document, the column headers are element or attribute names.

view_excel01

 

Copying from Standard Grid View

The examples shown above copied data from the Table View of Grid View (that is, with Table View toggled on in Grid View). In Standard Grid View (Table View toggled off), the Copy as Structured Text also copies the selected data as displayed in Grid View.  However, the structure is not a table. For example, in the Standard Grid View screenshot below, the items node, which has two item children, is selected.

view_table02

When the copied text is pasted in Microsoft Excel, the worksheet will look like the screenshot below.

view_excel02

In addition to copying the XML data as structured text with the Copy as Structured Text command, data can also be copied from Grid View as XML text.

 


© 2019 Altova GmbH