Excel Advanced Options

Módulo con opciones avanzadas para Excel

How to install this module

Download and install the content in ‘modules’ folder in Rocketbot path

How to use this module

This module needs to be installed Microsoft Excel with active license. If you need work with xlsx files without Excel application, use the Rocketbot commands in the Files secction

Overview

1. Open Without Alerts
   Open a file preventing MS Excel alerts.

2. Count columns
   Count the columns or return the last column name. It’s necessary that the excel is saved to get the last changes

3. Count Rows
   Counts all the rows or from a range.

4. Cell color
   Change color of a cell or range of cells. Can be a default color or custom

5. Insert Formula
   Insert formula into cell

6. Insert Macro
   Insert Macro in Excel

7. Select Cells
   Select cells in Excel

8. Get Cell With Currency Format
   Get cells with currency format

9. Get Cell With Date Format
   Get cells with date format

10. Copy-Paste
    Copy range cell to another sheet

11. Format Cell
    Format Cell

12. Create Sheet
    Create sheet in the end

13. Delete Sheet
    Delete sheet

14. Copy to another excel
    Copy range to another Excel in the background

15. Add/Delete Row
    Add or Delete a Row

16. Add/Delete Column
    Add or Delete a Column

17. Convert CSV to XLSX
    Convert a csv document to xlsx

18. Convert XLSX to CSV
    Convert a xlsx document to csv

19. Convert XLS to XLSX
    Convert a xls document to xlsx

20. Get active cell
    Get row and column of active cell

21. Refresh Pivot table
    Refresh a pivot table. Deprecated! Use PivotTableExcel module

22. Fit cells
    Adjusts, groups and ungroups a range of cells. You can group/ungroup by rows or columns

23. Get Formula
    Get the formula into cell

24. Add Auto Filter
    Add auto filter to excel table

25. Filter
    Add filter to excel table

26. Rename sheet
    Change name to excel sheet

27. Cell Style
    This command modifies the formatting of the selected cell or range of cells. You can change the font and borders

28. Paste in Cells
    Paste data to cells in Excel

29. Remove Duplicates
    Removes duplicate data in range

30. Close XLSX
    Close the workbook opened by Rocketbot

31. Save Excel
    Save a Excel file in the indicated path

32. Save Excel with password
    Save a Excel file

33. Export to advanced PDF
    Export to PDF with options

34. Copy-Move Sheet
    Copy or move a sheet

35. Insert Form
    Insert Form in Excel

36. Read Filtered Cells
    Allow read only cells filters

37. Count Filtered Cells
    Allow count only cells filters

38. Replace
    Run replace action to excel

39. Order
    Run replace action to excel

40. Refresh All
    Refresh all data in Excel

41. Find
    Return de first found cell

42. Lock Cells
    Lock or Unlock cells

43. Add Chart
    Create a new chart in an excel sheet

44. Remove Password
    Remove password and save the Excel

45. Insert image
    Insert an image

46. Export Chart
    Export a chart from index

47. Not visible mode
    Open not visible excel.

48. Write array objects
    Write array object on Excel cells.

49. Copy-Paste Format
    Copy format range cell to another sheet

50. Find and Connect
    Search a Excel Book opened and connect it

51. Update links
    Changes a link from one document to another

52. Unlock sheet
    Unlock sheet

53. Convert to .txt
    Convert to .txt

54. Text to columns
    Parses a column of cells that contain text into several columns.

55. Convert Excel time to hours
    Convert Excel time to hours. Returns the format as hh: mm: ss

56. Print sheet
    Prints a sheet

Updates

28-Dec-2021

• Count Rows: command fixed to count all rows.

9-Nov-2021

• Order command: Apply multiple orders and clean filters.

13-Oct-2021

• Fix count cells filtered

30-Sep-2021

• Paste command: Update compatibilities

28-Sep-2021

• Fix get filtered cells command. Now returns extended data

06-Jul-2021

• Fix language

01-Jul-2021

• Read Filtered Cells: The command was fixed because it didn’t getting all cell range

27-Apr-2021

• Texto to column: Parses a column of cells that contain text into several columns.

18-Mar-2021

• Unlock sheet: Convert XLSX to TXT.

09-Mar-2021

• Unlock sheet: Unlock a sheet by password.

09-Mar-2021

• Update links: Changes a link from one document to another

17-Feb-2021

• Find and Connect: Find opened Excel file and connect it

1-Feb-2021

• Add command Copy-Paste Format. You can copy format cell to another.

25-Jan-2021

• Write array objects: Writes information obtained from an array of objects to excel cells

21-Jan-2021

• Not visible mode: Open background Excel

1-Dec-2020

• Export chart: Export a chart from index.

24-Nov-2020

• Insert image in a cell.

24-Sep-2020

• Open without alerts: Add field ‘Password’

16-Sep-2020

• Add chart: Create a new chart on excel sheet

15-Sep-2020

• Lock Cells: Lock or unlock cells

2-Sep-2020

• Find: Replicate Excel Find command

31-Jul-2020

• Order: Replicate Excel Order command

15-Jul-2020

• Read Filtered Cells: Read cell after execute Filter command
• Replace: Replicate Excel Replace command

2-Jul-2020

• Insert Form: Rocketbot can insert VBA Form to Excel

30-Jun-2020

• Csv to xlsx: Checkbox header was added to decide if the csv has a header
• Export to Advanced PDF: Rocketbot export to PDF command enhancement
• Copy-Move Sheet: Replicate move/copy sheet command of Excel

17-Jun-2020

• Remove duplicates: Rocketbot can now remove duplicate data on range Excel

5-Jun-2020

• Focus Excel: Rocketbot can now set Excel to the foreground window

---

OS

• windows
• mac

Dependencies

• xlwings– pandas

License

MIT

GitHub

View Github