Pivot tables

Module to work and interact with Pivot Tables from Microsoft Excel.

Read this in other languages: English, Português, Español

How to install this module

To install the module in Rocketbot Studio, it can be done in two ways:

1. Manual: Download the .zip file and unzip it in the modules folder. The folder name must be the same as the module and inside it must have the following files and folders: _init_.py, package.json, docs, example and libs. If you have the application open, refresh your browser to be able to use the new module.
2. Automatic: When entering Rocketbot Studio on the right margin you will find the Addons section, select Install Mods, search for the desired module and press install.

Overview

1. Create
   Create a new pivot table

2. Refresh
   Refresh a pivot table

3. Add field
   Add field to a pivot table

4. Add calculated field
   Create a calculated field in a pivot table

5. Remove field
   Remove a field from a pivot table

6. Filter
   Filter a pivot table

7. Filter Values
   Filter a pivot table values

8. List Fields
   List all available table fields

9. Change pivot table data
   Change the source data range of a pivot table

10. List Filter Items
    Return all items from filter

11. Insert timeline
    Create a new timeline.

12. Filter slider
    Sets the timeline's filter.

13. Filter status
    Checks whether the element is marked in the field filter as visible or not visible. Return True or False respectively.

14. Change table format to tabular
    Changes the field of the pivot table to tabular format.

15. Delete subtotals
    Erase the subtotals from the pivot table.

16. Repeat label
    Allows to the pivot table to repeat labels.

17. Expand items
    Expand all items in the field that is collapsed

18. List pivot tables in sheet
    Returns a list with all pivot tables in the sheet

---

OS

• windows

Dependencies

• xlwings

License

MIT