XML.com: XML From the Inside Out
oreilly.comSafari Bookshelf.Conferences.

advertisement
 Resource Guide -> Demos, GUIs, Microsoft, Relational Databases, XML Editors -> Working with XML Tables

Working with XML Tables


Link: http://www.stylusstudio.com/xml_grid_view.html
Source Author or Organization: Stylus Studio

Stylus Studio provides an Enhanced Grid View for applying common XML editing operations on an entire XML document as a whole, instead of editing manually, line-by-line, saving time and effort.

  • 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.