Extracted demo UD$EX$Component:Demo UD$EX$Components: Creative views in the UD$SheetManager

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$ValuesSectionGroup
UD$VSG$Component
UD$VS$Component
UD$ValuesSection
US$ValuesSection
US$ValuesSectionGroup
@EX$Val
EX$RowMap
US$SheetManager
UD$SheetManager
UD$SheetManager⊙tree
Keywords
Slide kind
SysML Block Definition Diagram (BDD)
Click on the image to view it full size
Up next
Demo UD$EX$Components analyser
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
Related slides (backlinks, includes other tutorials)
Demo UD$EX$Components analyser
UD$EX$Components as (quick) XML
UD$EX$Component “database” demo (using a Wolfram Language EntityStore)