Spreadsheet Edit Processor

Applies structured edits to an XLSX workbook using a workbook and sheet abstraction for cell-level updates and sheet creation.

Capabilities

Applies structured sheet edits

• When no source workbook is provided, creates a workbook using the first edit's sheet name, writes the defined cells, appends the provided rows, and saves to destination. @test
• When a source workbook exists, loads it, creates any missing sheet listed in edits, applies cell updates before appending rows, and leaves sheets not referenced in edits unchanged. @test
• Cell coordinates use A1 notation; updates must occur before row appends so appended rows follow existing content without overwriting prior cells. @test

Persists workbook safely

• Saves the resulting workbook to the given destination path and closes any workbook and sheet handles so the file can be reopened immediately for verification. @test

Implementation

@generates

API

from pathlib import Path
from typing import Any, Dict, List, Optional, Sequence, TypedDict

class SheetEdit(TypedDict, total=False):
    sheet: str
    create_if_missing: bool
    cells: Dict[str, Any]
    append_rows: List[List[Any]]

def apply_workbook_edits(
    destination: Path,
    edits: Sequence[SheetEdit],
    source: Optional[Path] = None,
) -> Path:
    """Load or create an XLSX workbook, apply cell updates and row appends per sheet, and save to destination."""

Dependencies { .dependencies }

pyexcel-xlsx { .dependency }

Provides workbook and sheet abstractions for creating sheets, editing cell values, appending rows, and saving XLSX content efficiently.