Agent skill

xlsx-to-python

Convert Excel calculation spreadsheets to Python code — extract formulas, build dependency graphs, generate pytest tests using cell values as assertions, and produce dark-intelligence archive YAMLs.

View SKILL.md on GitHub Repository
Stars 4
Forks 4

Install this agent skill to your Project

npx add-skill https://github.com/vamseeachanta/workspace-hub/tree/main/.claude/skills/data/office/xlsx-to-python

SKILL.md

Xlsx To Python

When to Use

  • Porting engineering calculations from Excel to Python
  • Extracting calculation methodology from legacy spreadsheets
  • Building dark-intelligence archives from XLSX files
  • Any time a spreadsheet contains formulas that should become code

Sub-Skills

  • Core Principle: Excel Values = Test Data
  • Recommended Stack (+2)
  • openpyxl Limitation (+3)
  • Step 1 — Dual-Pass Loading (+5)
  • Step 6 — Calculation Block Detection
  • Test Assertion Patterns by Data Type (+1)
  • Dark Intelligence Archive Generation
  • Using formulas for Complex Workbooks
  • Why Parametric Variations Are Required (+4)
  • Research Finding: No Existing Library Does This (+5)
  • Integration with Existing Pipeline
  • Checklist

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

vamseeachanta/workspace-hub

gsd-complete-milestone

Archive completed milestone and prepare for next version

4 4
Explore
vamseeachanta/workspace-hub

gsd-reapply-patches

Reapply local modifications after a GSD update

4 4
Explore
vamseeachanta/workspace-hub

gsd-verify-work

Validate built features through conversational UAT

4 4
Explore
vamseeachanta/workspace-hub

gsd-thread

Manage persistent context threads for cross-session work

4 4
Explore
vamseeachanta/workspace-hub

clinical-trial-protocol

Generate clinical trial protocols for medical devices or drugs through a modular, waypoint-based architecture with research-only and full protocol modes.

4 4
Explore
vamseeachanta/workspace-hub

single-cell-rna-qc

Performs quality control on single-cell RNA-seq data (.h5ad or .h5 files) using scverse best practices with MAD-based filtering and comprehensive visualizations.

4 4
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results