Cube Excel

Module to work with Excel OLAP/Cube Pivot Tables

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. Refresh Pivot table
   Refresh a pivot table

2. Add Field - Cube
   Add field to a pivot table

3. Remove Field - Cube
   Remove field from a pivot table

4. Add Filter - Cube
   Filter a pivot table

5. Apply Filter - Cube
   Filter a pivot table

6. Clear Filter - Cube
   Clear a filter from a pivot table

7. Clear All Filters - Cube
   Clear all filters from a pivot table

8. List Visible Items - Cube
   List visible items of a field from a Pivot Table - Cube

9. Open Field
   Open a field. Similar to click on plus button

10. List Fields
    List all available table fields

11. List SubField
    List Pivot Table from a Cube Field

---

OS

• windows
• mac

Dependencies

• xlwings

License

MIT