UD$EX$Components as (quick) XML

Gallery
Tutorial
[TECHNICAL SLIDE TRAIL] The Webel libraries for Wolfram Mathematica: With SysMLv1 models.
Section
SECTION: Webel ADT case study: Extracting structured data from unstructured Open XML spreadsheet data
Mathematica keywords
XMLElement
Webel Mathematica keywords
ADT`
Webel ADT
UD$EX$Component
UD$EX$Components
UD$EX$Components⊙asXMLElement
ADT⊙asXMLElement
xml$tree
XML`
UD`
Keywords
Click on the image to view it full size

The base Webel ADT and EX$Val have some support for creating basic XML via the Wolfram Language XMLElement, and the Webel XML` package has additional XML support.

The Wolfram Language is particularly well suited to working with XML. The quick contrived XML "schema" as shown in the slide for the UD$EX$Components analyser (an ADT$List extension with UD$EX$Component items) took only about ten minutes to create (and some time preparing the slide presentation).

Specific industry XML formats and compliance with a formal XML Schema is beyond the scope of this slide trail presentation. It is worth noting that Mathematica can also easily speak to Python or Java, so can leverage many existing XML Schema libraries.

Any Wolfram Language expression can also be serialised with just one command using the "ExpressionML" format (not shown here).

Note also that all remarks here about using the Wolfram Language with XML apply similarly when working with JSON.

Up next
UD$EX$Component “database” demo (using a Wolfram Language EntityStore)
Notes
Snippets (quotes/extracts)
Visit also
Mathematica: POLICY NOTES for the Webel Abstract Data Type (ADT) pseudo classes with inheritance for the Wolfram Language
Visit also (backlinks)
Related slides (includes other tutorials)
adt$store, adt$fetch, and «adt:ref»: Example: Reference XL$ResourcesMap by ID in US$ResourcesHolder.
XL$Cell value resolution for “text” requires an XL$ResourcesMap (Real, Integer, and Boolean value resolution does not)
UUID-driven Once-caching. Example: XL$Cell value resolution with an XL$ResourcesMap
Webel ADT hierarchy views as tree, graph, and SysML
ADT hierarchy for the XL` package for reading unstructured data from OpenXML XLSM bundles
Overview of the Webel OpenXML libraries ADT Case Study
Typical unstructured spreadsheet data imported into the XL layer
XL$Row and XL$Cell under the hood
XL$Cell with a VBA formula and XL$F
Spreadsheet “units indicator” HACKS do NOT use a units-aware Quantity algebra!
Units and Quantity extraction with US$Row
US$RowList spanned rows filling
US$RowList sub-list extraction
US$RowList & EX$RowMap column extraction and custom styled tables
US$RowList “section” extraction
UD` demo package for US$Section
UD` demo: Basic US$ValuesSection
US$ValuesSection to EX$RowMap
US$SectionMap auto-detection
Specific Component-aware sub-ADTs
Demo Component values extraction (but not yet as EX Component ADTs)
The demo UD$EX$Component for extracted structured EX Layer data
Extracted demo UD$EX$Component:Demo UD$EX$Components: Creative views in the UD$SheetManager
Demo UD$EX$Components analyser
Related slides (backlinks, includes other tutorials)
UD$EX$Component “database” demo (using a Wolfram Language EntityStore)
External links
Wolfram Language Documentation: Exporting XML
Wolfram Language Documentation: XML
Wolfram Language Documentation: XML Formats
Wolfram Language Documentation: XML Import & Export
Wolfram Language Documentation: XML Capabilities
Wolfram Language Documentation: Representing XML
Wolfram Language Documentation: Transforming XML