XLSX Plugin IO Utility

A small utility that relies on the XLSX plugin to let the spreadsheet toolkit read and write workbooks from disk paths, in-memory streams, and raw content bytes while keeping sheet order and empty sheets intact.

Capabilities

Load from filesystem

• Reading the provided fixtures/sample.xlsx returns ordered sheets { "Budget": [["Item", "Cost"], ["Lunch", 12]], "Empty": [] }, preserving sheet order and the empty sheet. @test

Load from in-memory stream

• Given a binary stream containing workbook bytes for { "Log": [["Row"], ["A"], ["B"]] }, the loader returns that mapping; writing { "Log": [["Row"], ["C"]], "Totals": [["Count", 1]] } to a new stream yields bytes that reload to the same rows. @test

Load from raw content bytes

• Given raw bytes representing { "Scores": [["Name", "Score"], ["Ada", 9], ["Turing", 10]] }, the loader returns that mapping; serializing { "Scores": [["Name", "Score"], ["Ada", 9], ["Turing", 10]] } back to bytes reloads to identical order and values. @test

Implementation

@generates

API

from typing import Any, BinaryIO, Dict, List, OrderedDict

def load_from_path(path: str) -> OrderedDict[str, List[List[Any]]]:
    """Load workbook data from a filesystem path, preserving sheet order and empty sheets."""

def load_from_stream(stream: BinaryIO) -> OrderedDict[str, List[List[Any]]]:
    """Load workbook data from an open binary stream; the stream may be reused after rewind."""

def load_from_content(content: bytes) -> OrderedDict[str, List[List[Any]]]:
    """Load workbook data from raw bytes."""

def save_to_path(data: Dict[str, List[List[Any]]], path: str) -> None:
    """Write sheet data to a filesystem path, preserving sheet order."""

def save_to_stream(data: Dict[str, List[List[Any]]]) -> bytes:
    """Write sheet data into an in-memory binary stream and return its bytes."""

def save_to_content(data: Dict[str, List[List[Any]]]) -> bytes:
    """Serialize sheet data to raw bytes suitable for reloading."""

Dependencies { .dependencies }

pyexcel { .dependency }

Spreadsheet read/write framework with plugin hooks.

pyexcel-xlsx { .dependency }

Registers the XLSX IO plugin for file, memory stream, and content bytes handling.