build_excel_workbook()

Build a Workbook with component mapping and representation map sheets.

Usage

Source

build_excel_workbook(
    components,
    rep_maps=None,
)

The primary sheet comp_mapping contains three columns: source, target, and mapping_rules, with hyperlinks for components that have a representation map.

Parameters

components: Sequence[str]

An ordered list of unique target component IDs.

rep_maps: Sequence[str] | None = None

A sequence of names (matching component IDs) for which dedicated representation mapping tabs should be created. Internally deduplicated via conversion to a set.

Returns

Workbook

An openpyxl Workbook object populated with sheets and headers.

Raises

ValueError

If components validation fails (delegated to helper).

TypeCheckError

If any input argument fails type validation.

RuntimeError

If sheet creation fails due to invalid sheet names.