Intuitive XML Viewers: The Grid View is one of four, synchronized XML editing views integrated
in the Stylus Studio XML editor, giving developers the flexibility to work with XML
technologies in the mode that best suits their specific needs, thus simplifying XML development. The Stylus
Studio XML design pane includes several view tabs that allow you to quickly switch back and forth between the different XML views
Working with XML Tables: The Grid View in Stylus Studio
flattens the hierarchical structure of XML-compliant documents
using nested data tables. These nested XML tables can then be expanded and collapsed to visualize
the XML document's tree structure. Only Stylus Studio allows you to directly
manipulate your document in this hierarchical XML grid (XML table) view using
advanced drag-and-drop, copy/paste, as well as XML code completion and
live XML syntax help as you type. The Grid View automatically detects
sequences of repeating elements and attributes, displaying these repeating structures as XML tables. This tabular view is a well-known
paradigm that resembles database- or spreadsheet-like applications.
Working with XML and Relational Data: The Grid View (also
known as a database or table view) is fully integrated with the XML Text View
and other XML editing vies, and you can switch between both presentation forms.
Editing in the table view is supported through advanced drag-and-drop and
intelligent editing functions, and you can work with XML data as you would in a
spreadsheet or database application.
Working with XML and Microsoft Excel: For easy data
exchange with other applications, you can select elements from an XML table and
copy/paste it into Microsoft Excel or Microsoft Access. This feature works both
ways, so you can also copy non-XML data from Microsoft Excel or any other
database product, into the XML Grid – Stylus Studio will automatically add the
required XML markup.
Converting XML Table Data: For more complex data conversion
tasks, Stylus Studio also offers a set of unique data conversion utilities, which
allow you to import/export XML data from any flat-file, EDI, or database such as
Oracle9i, Microsoft SQL Server 2005, and many other databases. Using XML
deployment adapters and an integrated Java Code Generator, developers can automate data
conversions as part of their customized Java applications.