ADT hierarchy for the XL` package for reading unstructured data from OpenXML XLSM bundles

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
UML keywords
Stereotype
Stereotype:icon
Webel Mathematica keywords
ADT`
Webel ADT
XL`
XL$RowList
XL$XL
adt$graphHierarchy
Keywords
Click on the image to view it full size
For reference, an associated Policy Note (you don't need to visit this link yet):
Webel: SysML4Mathematica (v2): The long term goal is generation of SysMLv2 models using the SysMLv2 modelling code (textual representation) and generation of SysMLv2 Diagrams directly in Mathematica, corresponding with the trend to generative diagramming.
Up next
ADT hierarchy for the US` package with intermediate unstructured data and identification of data groups
Notes
[]{INFORMATIVE} Webel: SysML4Mathematica (v2): The long term goal is generation of SysMLv2 models using the SysMLv2 modelling code (textual representation) and generation of SysMLv2 Diagrams directly in Mathematica, corresponding with the trend to generative diagramming.
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)
Webel ADT hierarchy views as tree, graph, and SysML
Overview of the Webel OpenXML libraries ADT Case Study
Related slides (backlinks, includes other tutorials)
ADT hierarchy for the US` package with intermediate unstructured data and identification of data groups
ADT hierarchy for the EX`package for extracted structured data
ADT hierarchy for a typical Client Data (CD) layer for identifying structured data groups
Typical unstructured spreadsheet data imported into the XL layer
XL$Row and XL$Cell under the hood
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
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
XL$RowList vs XL$Row vs XL$Cell
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
The US$SheetManager as a bridge between the US Layer and EX Layer
Extracted demo UD$EX$Component:Demo UD$EX$Components: Creative views in the UD$SheetManager
Demo UD$EX$Components analyser
UD$EX$Components as (quick) XML
UD$EX$Component “database” demo (using a Wolfram Language EntityStore)