v0.4.0

Features

• excel_runner can now either accept a dict of lists (like table columns) or a list of dicts (like table rows) as input.
• excel_runner now accepts dicts that are not keyed by cell references so long as the (new) optional static_input_maps is passed which allows cell references to be mapped onto dict keys (this prevents you from having to re-key your existing data with cell references).

v0.3.0

Feature

• Ability to used named cells now instead of just cell references (like, anywhere).

v0.2.0

Breaking changes

• Updates to API
• Improved README.md
• Updated tests

v0.1.1 for GHA

Merge pull request #2 from StructuralPython/releases/v0.1.0

Bump version

v0.1.1

Updated pyproject.toml to have a loose requirement for rich

v0.1.0 - Initial release

xl-engine

xl-engine consists of a few functions that wrap the functionality of XLWings to make it convenient to parameterize and execute Excel workbooks as though they were Python functions.

While it can be used by a general audience, the excel_runner function was designed with the needs of design engineers in mind. This means that there are two sets of inputs: a static set and a dynamic set. The static set is input for all iterations, and the dynamic set is iterated over.

There are many possible implementations of this functionality but this is according to my own preferences. This is a personal tool that I used to teach (and that I actively use) and I have decided to publish it for ease of use and distribution.