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).
In the screenshot below two rows in the Table View of Grid View are copied as structured text.
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.
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.
In the screenshot below, a whole table is selected (by clicking the item (6) node entry).
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.
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.
When the copied text is pasted in Microsoft Excel, the worksheet will look like the screenshot below.
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