



# 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. 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**](https://pypi.org/project/xlwings/)
### License
  
![MIT](https://camo.githubusercontent.com/107590fac8cbd65071396bb4d04040f76cde5bde/687474703a2f2f696d672e736869656c64732e696f2f3a6c6963656e73652d6d69742d626c75652e7376673f7374796c653d666c61742d737175617265)  
[MIT](http://opensource.org/licenses/mit-license.ph)