Lightlines
By anthropics

xlsx

anthropics177.8k installs

Get spreadsheets with formulas that recalculate.

What it does

Creates, edits, repairs, and converts spreadsheet files with formatting and recalculable formulas.

When to use it

Use when a spreadsheet is the primary input or output, including cleaning messy tables and converting tabular files.

How to use it

Give it a spreadsheet task and any existing data files; it returns a created, edited, repaired, or converted spreadsheet file.

What you provide

  • Your files

Uses

Good to know

  • cannot be undone: output.xlsx

Latest review

What you need · 4

Requires Python to run the bundled formula-recalculation script.

Uses openpyxl to create and edit workbooks and inspect recalculated formulas; the instructions expect it to be preinstalled.


Access · 6

This skill

output.xlsx

Write

Rewrites spreadsheets in place (irreversible)

openpyxl

Execute

Installs openpyxl if missing