XLSX To Python Core Principle Excel Values Test Data

Sub-skill of xlsx-to-python: Core Principle: Excel Values = Test Data.

vamseeachanta Updated 20 repo stars

File contents

Core Principle: Excel Values = Test Data

Core Principle: Excel Values = Test Data

When an Excel spreadsheet contains a calculation with input values and computed results, those cell values are the test cases. The two-pass extraction strategy:

  • Pass 1 (data_only=True): read computed cell values — these become pytest.approx() assertions
  • Pass 2 (data_only=False): read formula strings — these become Python function implementations

This means every spreadsheet with formulas is simultaneously a specification, an implementation reference, AND a test fixture.

vamseeachanta/workspace-hub commit ac8c176107

Frequently asked questions

npx get-skill add vamseeachanta/xlsx-to-python-core-principle-excel-values-test-data-2