US$RowList “section” extraction

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
US layer
US$Row
US$RowList
EX$RowMap
Keywords
Click on the image to view it full size
Up next
UD` demo package for US$Section
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
Related slides (backlinks, includes other tutorials)
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)