set_auto_filter
Add filter dropdowns to an Excel data range for easy data sorting and filtering. Optionally remove existing filters.
Instructions
Add Excel's filter dropdowns to a data range (one filter per sheet).
range should cover the header row plus data, e.g. 'A1:D50'; omit it to use the sheet's whole used range. Pass remove=true to clear the sheet's filter. This adds the filter UI — choosing filter values happens in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | No | ||
| sheet | No | ||
| remove | No | ||
| session_id | Yes |