Release 5.13.5

Write cell command: handling for writing a matrix, so that the data is filled not only in the rows but also in the subsequent columns.

Release 5.13.4

Add:
New command: Write Cell.

Fix:
Column Filter command: fix duplicated results.

Release 5.12.3

Add:
- New command Protect sheet: protect an Excel sheet with a password.

Release 5.11.3

Fix github action

Release 5.11.2

New command Close XLSX

Release 5.10.2

Add:

Advanced_xlsx,py:
It was observed that sometimes the xls files did not have a sheet name. Therefore, a default value of "Sheet1" was set for those cases.
The rows were being encoded in latin-1 but then decoded in utf-8. A correction was applied by adding a select option to the "Open xls" and "Convert xls to xlsx" commands to choose between latin-1 and utf-8 encoding (if none is selected, latin-1 is used by default).
ReadRange: It is observed that the command only returns information when a range of cells is provided. If only a single cell is specified, for example A1, no information is retrieved. A correction has been applied.

Release 5.10.1

Add:
- New command Open advanced xlsx: command to open an xlsx with advanced configuration parameters.

Release 5.9.1

Fix:

- Filter by Column Command: condition is added to filter by empty cells indicating, since it was not doing it correctly.

Release 5.8.0

Minor:

• Column Filter: Improve command to filter by dates.

Medium:

• Read Range: New command to read a cell or range.

Release 5.7.5

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.

Updates

New

• Insert Image: Insert image into an specific cell into a document
• Rename sheet: Change the name of a sheet

Fix

-Update Libs

• Add remove_vars