xlsx_slicers_timelines
Extract all slicer and timeline metadata from a local .xlsx file. Use to document dashboard filter UI for AI agents or audit slicer bindings after data changes.
Instructions
List every slicer (interactive filter button) and timeline (date-range filter visual) in a LOCAL .xlsx file with their captions, source bindings (table column or pivot table), and timeline granularity (years / quarters / months / days) plus the currently-selected date range.
Reads the OOXML zip (xl/slicers/, xl/slicerCaches/, xl/timelines/, xl/timelineCaches/) directly — a surface ExcelJS silently drops on round-trip.
USE WHEN: documenting a dashboard so an LLM knows what filter UI a human sees. Or auditing whether a slicer's binding still matches the underlying data after a refactor.
DO NOT USE WHEN: just reading values (use xlsx_read). Or trying to APPLY a filter (use xlsx_filter — slicers/timelines are UI metadata, not data filters).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes |