xlsx_styles
Recover cell formatting (number formats, fonts, fills) discarded by pandas, enabling LLMs to interpret date serials, currency, and percentages correctly.
Instructions
surface cell formatting (number formats, fonts, fills, alignment) so an agent knows what a cell LOOKS like, not just its raw value. Default mode: per-sheet rollup of top-N number formats / fonts / fills with counts. Detailed mode (opt-in, capped at 1000 cells): per-cell breakdown for narrow queries. No other tool can do this with this fidelity: pandas drops styles on read entirely. The single most valuable slice is number formats — pandas hands an LLM "45292" and the cell rendered as "2024-01-01" because format was "yyyy-mm-dd". xlsx_styles is what makes that recoverable.
USE WHEN: an LLM is about to interpret raw numbers (date serials, currency, percents, scientific notation) and you want the format hint that tells it what those numbers MEAN to a human. Or auditing a dashboard's typography. Or fingerprinting a template. Free tier — counts against the 10k/mo cap.
DO NOT USE WHEN: you only need the data (use xlsx_read which already includes basic numFmt hints in the output).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes | ||
| options | No |