xlsx/extended-properties-basic

Parameter axes

• field (7 values): application, app-version, company, doc-security, manager, template, words

Spec notes

Generator source

scripts/gen_extended_properties_basic_xlsx.py — runs with --arg_template --field {field.id} --value "{field.value}" --out fixtures/xlsx/extended-properties-basic--{field.id}.xlsx

#!/usr/bin/env python3
"""Generate ``fixtures/xlsx/extended-properties-basic--<field>.xlsx`` fixtures.

Parameterised generator; drives ``features/xlsx/extended-properties-basic.json``.

python-xlsx's ExtendedProperties ships with a restricted ``__elements__`` tuple
(only Application / AppVersion / DocSecurity + boolean flags are serialised by
default). To exercise Company / Manager / Template / Words we monkey-patch the
tuple so the Serialisable machinery emits the field under test. This is a
generator-side workaround, not a runtime library change -- the underlying
library keeps its usual output shape for any other caller.
"""

from __future__ import annotations

import argparse
import datetime as _dt
from pathlib import Path

from xlsx import Workbook

_REPO_ROOT = Path(__file__).resolve().parent.parent
_REPRODUCIBLE_DT = _dt.datetime(2000, 1, 1, 0, 0, 0)

_PINNED_CREATED = _dt.datetime(2026, 1, 1, 0, 0, 0)
_PINNED_MODIFIED = _dt.datetime(2026, 1, 2, 0, 0, 0)

# Scalar fields that must be opted-in via ``__elements__`` before python-xlsx
# will emit them. Cases targeting one of these fields append the XML name to
# the instance ``__elements__`` tuple before save.
_OPT_IN_ELEMENTS = {
    "company": "Company",
    "manager": "Manager",
    "template": "Template",
    "words": "Words",
    "pages": "Pages",
    "hyperlink-base": "HyperlinkBase",
}


def _apply(wb, field: str, value: str) -> None:
    ep = wb.extended_properties
    opt_in = _OPT_IN_ELEMENTS.get(field)
    if opt_in is not None and opt_in not in ep.__elements__:
        ep.__elements__ = ep.__elements__ + (opt_in,)
    if field == "application":
        ep.Application = value
    elif field == "app-version":
        ep.AppVersion = value
    elif field == "company":
        ep.Company = value
    elif field == "doc-security":
        ep.DocSecurity = int(value)
    elif field == "manager":
        ep.Manager = value
    elif field == "template":
        ep.Template = value
    elif field == "words":
        ep.Words = int(value)
    else:
        raise SystemExit(f"Unknown field id: {field!r}")


def main() -> int:
    parser = argparse.ArgumentParser()
    parser.add_argument("--field", required=True)
    parser.add_argument("--value", required=True)
    parser.add_argument(
        "--out",
        default=str(_REPO_ROOT / "fixtures" / "xlsx" / "extended-properties-basic.xlsx"),
    )
    args = parser.parse_args()

    out_path = Path(args.out)
    if not out_path.is_absolute():
        out_path = _REPO_ROOT / out_path

    wb = Workbook()
    wb.properties.created = _PINNED_CREATED
    wb.properties.modified = _PINNED_MODIFIED
    wb.properties.creator = ""
    _apply(wb, args.field, args.value)
    out_path.parent.mkdir(parents=True, exist_ok=True)
    wb.save(out_path, zip_date_time=_REPRODUCIBLE_DT)
    print(out_path)
    return 0


if __name__ == "__main__":
    raise SystemExit(main())

Manifest (parent, unexpanded)

{
  "$schema": "../manifest.schema.json",
  "id": "xlsx/extended-properties-basic",
  "kind": "parameterised",
  "title": "Extended (app) properties: common scalar fields",
  "format": "xlsx",
  "category": "metadata",
  "summary": "The ``docProps/app.xml`` part carries application-level metadata (Application, AppVersion, Company, DocSecurity, Manager, Template, Words). Each case isolates one field, so each XPath assertion proves that particular field round-trips via python-xlsx's Workbook.extended_properties API.",
  "spec": {
    "source": "ecma-376-5-part-4",
    "clause": "22.2",
    "notes": "ECMA-376 Part 4 / ISO 29500-4 section 22.2 defines the extended-properties part. python-xlsx's ExtendedProperties class ships a restricted default ``__elements__`` tuple (Application / AppVersion / DocSecurity and a handful of boolean scalars) so Company / Manager / Template / Words / HyperlinkBase need an explicit opt-in to be serialised; the generator augments ``__elements__`` at runtime to include whichever field is under test. If python-xlsx later broadens its default serialisation set, the generator hack becomes a no-op and the family continues to pass."
  },
  "fixtures": {
    "machine": "xlsx/extended-properties-basic"
  },
  "generator": {
    "python": "scripts/gen_extended_properties_basic_xlsx.py",
    "arg_template": "--field {field.id} --value \"{field.value}\" --out fixtures/xlsx/extended-properties-basic--{field.id}.xlsx"
  },
  "parameters": {
    "field": [
      {
        "id": "application",
        "value": "Loadfix python-xlsx",
        "xpath": "//ep:Application"
      },
      {
        "id": "app-version",
        "value": "16.0000",
        "xpath": "//ep:AppVersion"
      },
      {
        "id": "company",
        "value": "Loadfix Inc.",
        "xpath": "//ep:Company"
      },
      {
        "id": "doc-security",
        "value": "0",
        "xpath": "//ep:DocSecurity"
      },
      {
        "id": "manager",
        "value": "Eve Manager",
        "xpath": "//ep:Manager"
      },
      {
        "id": "template",
        "value": "Book.xltx",
        "xpath": "//ep:Template"
      },
      {
        "id": "words",
        "value": "42",
        "xpath": "//ep:Words"
      }
    ]
  },
  "assertions_template": [
    {
      "id": "ext-{field.id}-present",
      "part": "docProps/app.xml",
      "namespaces": {
        "ep": "http://schemas.openxmlformats.org/officeDocument/2006/extended-properties"
      },
      "xpath": "{field.xpath}",
      "must": "exist",
      "description": "The {field.id} element must be present in docProps/app.xml."
    },
    {
      "id": "ext-{field.id}-value",
      "part": "docProps/app.xml",
      "namespaces": {
        "ep": "http://schemas.openxmlformats.org/officeDocument/2006/extended-properties"
      },
      "xpath": "{field.xpath}",
      "must": "equal",
      "value": "{field.value}",
      "description": "The {field.id} element's text must equal the supplied value."
    }
  ]
}