Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Excel Slicers
This Bot can select one or more items or clear an existing filter on an Excel Slicer to filter data in a report or pivot table.
Top Benefits
- 100% Accurate filtering of Excel data with slicers
- Enhances functionality of AA Excel Command
- Simple to deploy and use
Tasks
- Selects one to many slicer items on an Excel Slicer
- Clear any currently filtered Excel Slicer
- Return information on slicers within Excel workbook
This Bot allows you to set an instance of a currently open Excel workbook and perform a series of actions on Excel Slicers. This allows you to filter an Excel pivot output, such as a report, to the specifications of the business before releasing.
The slicer selection works with pivots generated by data from a worksheet, a database or an OLAP cube.