



# XLSX Advanced Options
  
Format cells, create and remove sheets, filter data, add and delete columns and rows, open xls files and transform them into xlsx format.  

*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. Open xls  
Open a xls file to work with native command

2. Open advanced xlsx  
Open a xlsx file to work with native command

3. Convert xls to xlsx  
Convert an xls format file to xlsx format

4. Convert sheet to csv  
Convert a sheet of the opened xlsx file to csv

5. Write cell  
Writes a value in a specific cell. If an array is passed, writes each value vertically in the same column.

6. Read range  
Returns the value of the given range. One value if the range is a cell or a list if the range has multiple cells.

7. Rename sheet  
Rename a sheet

8. Format cells  
Give format to cells

9. Create sheet  
Create a new sheet

10. Protect Sheet  
Protect Sheet

11. Remove sheet  
Remove a sheet from workbook

12. Count in range  
Returns the maximum number of rows and columns from a cell

13. Column filter  
Filter by column

14. Delete Row/Column  
Command to delete rows or columns

15. Insert Row/Column  
Command to insert rows or columns

16. Insert image  
Insert an image into a document

17. Close xlsx  
Close an open xlsx file  




----
### OS

- windows
- mac
- linux
- docker

### Dependencies
- [**openpyxl**](https://pypi.org/project/openpyxl/)- [**tablepyxl**](https://pypi.org/project/tablepyxl/)- [**xlrd**](https://pypi.org/project/xlrd/)
### License
  
![MIT](https://camo.githubusercontent.com/107590fac8cbd65071396bb4d04040f76cde5bde/687474703a2f2f696d672e736869656c64732e696f2f3a6c6963656e73652d6d69742d626c75652e7376673f7374796c653d666c61742d737175617265)  
[MIT](http://opensource.org/licenses/mit-license.ph)