XL`

XL` A Wolfram Language package within the Webel libraries for Mathematica. Webel Abstract Data Types (ADTs) for importing "unstructured" Open XML format spreadsheet data. For a full description visit this detailed slide trail:

[TECHNICAL SLIDE TRAIL] The Webel libraries for Wolfram Mathematica: With SysMLv1 models.

XL$RowList vs XL$Row vs XL$Cell

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

XL$Cell with a VBA formula and XL$F

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

UUID-driven Once-caching. Example: XL$Cell value resolution with an XL$ResourcesMap

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

XL$Cell value resolution for “text” requires an XL$ResourcesMap (Real, Integer, and Boolean value resolution does not)

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

XL$Row and XL$Cell under the hood

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

Typical unstructured spreadsheet data imported into the XL layer

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

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

Overview of the Webel OpenXML libraries ADT Case Study

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

Subscribe to XL`