Demo UD$EX$Components analyser

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
Webel Mathematica keywords
ADT`
Webel ADT
UD$EX$Component
UD$EX$Components
UD$EX$Components⊙ud$ex$selectRealTemp
UD$EX$Components⊙tableAll
UD$EX$Components⊙table$vReal
UD$EX$Components⊙table$vBool
Keywords
Slide kind
SysML Block Definition Diagram (BDD)
Click on the image to view it full size
For reference, an associated Policy Note (you don't need to visit this link yet):
Mathematica: Webel ADT pseudo classes: 'Q: Do I have to use these EX$Val scalar "atom" thingies and the EX$Row, EX$RowList, and EX$RowMap? Can't I just use Wolfram Language Lists and Associations?' A: Of course you can also use the basic Wolfram Language!
Up next
UD$EX$Components as (quick) XML
Notes
[CAPABILITY]{SUBJECT-TO-CHANGE} Mathematica: Webel ADT pseudo classes: 'Q: Do I have to use these EX$Val scalar "atom" thingies and the EX$Row, EX$RowList, and EX$RowMap? Can't I just use Wolfram Language Lists and Associations?' A: Of course you can also use the basic Wolfram Language!
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
Related slides (backlinks, includes other tutorials)
UD$EX$Components as (quick) XML
UD$EX$Component “database” demo (using a Wolfram Language EntityStore)