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 Tags and keywords Mathematica keywords XMLElement Webel Mathematica keywords ADT` Webel ADT XL layer XL` OpenXML XL$Cell XL$RowList XL$Row XL$RowList⊙nRows XL$RowList⊙nSheetRows XL$RowList⊙drawTable XL$RowList⊙get$xl$rowList XL$RowList⊙xl$extractSelectedColumns Keywords Wolfram Wolfram Language Mathematica Webel::SysML4Mathematica Webel IT Australia Abstract Data Types Webel:ADT Systems Modeling Language SysMLv1 Click on the image to view it full size Webel IT Australia prefers to use examples from real client projects but usually heavily obfuscates, masks, or randomises client-specific data. Educational examples do not expose client data without permission. Up next Spreadsheet “units indicator” HACKS do NOT use a units-aware Quantity algebra! Notes [EXPLANATION, TIP]{RECOMMENDED} Mathematica: SUPER TIP: Use CreateUUID[] to trigger recalculation against Once[] to create a flexible optionally caching function! (May incur a memory penalty, consider also using a 'loc' persistence location.) [CONVENTION, POLICY]{STRICT} Mathematica: Webel ADT pseudo classes: POLICY: The Abstract Data Types (ADTs) are stateless functional (although inheritance and overrides are supported), with no caching by default (although there is nice optional caching using CreateUUID[] and Once[]). [POLICY]{INFORMATIVE} Webel IT Australia prefers to use examples from real client projects but usually heavily obfuscates, masks, or randomises client-specific data. Educational examples do not expose client data without permission. 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) 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 Related slides (backlinks, includes other tutorials) Flags Book traversal links for XL$RowList vs XL$Row vs XL$Cell Previous Up Next
