



# Pivot tables

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

*Read this in other languages: [English](README.md), [Português](README.pr.md), [Español](README.es.md)*

## 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. Remove field
Remove a field from a pivot table

5. Filter
Filter a pivot table

6. Filter Values
Filter a pivot table values

7. List Fields
List all available table fields

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

9. List Filter Items 
Return all items from filter

10. Insert timeline
Create a new timeline.

11. Filter slider
Sets the timeline's filter.

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

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

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

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

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

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




----
### OS

- windows
- mac

### Dependencies
- [**xlwings**](https://pypi.org/project/xlwings/)
### License

![MIT](https://img.shields.io/github/license/instaloader/instaloader.svg)
[MIT](https://opensource.org/license/mit)