README

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, Português, Español

How to install this module

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

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.
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.

Open xls
Open a xls file to work with native command
Open advanced xlsx
Open a xlsx file to work with native command
Convert xls to xlsx
Convert an xls format file to xlsx format
Convert sheet to csv
Convert a sheet of the opened xlsx file to csv
Write cell
Writes a value in a specific cell. If an array is passed, writes each value vertically in the same column.
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.
Rename sheet
Rename a sheet
Format cells
Give format to cells
Create sheet
Create a new sheet
Protect Sheet
Protect Sheet
Remove sheet
Remove a sheet from workbook
Count in range
Returns the maximum number of rows and columns from a cell
Column filter
Filter by column
Delete Row/Column
Command to delete rows or columns
Insert Row/Column
Command to insert rows or columns
Insert image
Insert an image into a document
Close xlsx
Close an open xlsx file