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
-
Open Without Alerts
Open a file preventing MS Excel alerts. -
Count columns
Count the columns or return the last column name. It’s necessary that the excel is saved to get the last changes -
Count Rows
Counts all the rows or from a range. -
Cell color
Change color of a cell or range of cells. Can be a default color or custom -
Insert Formula
Insert formula into cell -
Insert Macro
Insert Macro in Excel -
Select Cells
Select cells in Excel -
Get Cell With Currency Format
Get cells with currency format -
Get Cell With Date Format
Get cells with date format -
Copy-Paste
Copy range cell to another sheet -
Format Cell
Format Cell -
Create Sheet
Create sheet in the end -
Delete Sheet
Delete sheet -
Copy to another excel
Copy range to another Excel in the background -
Add/Delete Row
Add or Delete a Row -
Add/Delete Column
Add or Delete a Column -
Convert CSV to XLSX
Convert a csv document to xlsx -
Convert XLSX to CSV
Convert a xlsx document to csv -
Convert XLS to XLSX
Convert a xls document to xlsx -
Get active cell
Get row and column of active cell -
Refresh Pivot table
Refresh a pivot table. Deprecated! Use PivotTableExcel module -
Fit cells
Adjusts, groups and ungroups a range of cells. You can group/ungroup by rows or columns -
Get Formula
Get the formula into cell -
Add Auto Filter
Add auto filter to excel table -
Filter
Add filter to excel table -
Rename sheet
Change name to excel sheet -
Cell Style
This command modifies the formatting of the selected cell or range of cells. You can change the font and borders -
Paste in Cells
Paste data to cells in Excel -
Remove Duplicates
Removes duplicate data in range -
Close XLSX
Close the workbook opened by Rocketbot -
Save Excel
Save a Excel file in the indicated path -
Save Excel with password
Save a Excel file -
Export to advanced PDF
Export to PDF with options -
Copy-Move Sheet
Copy or move a sheet -
Insert Form
Insert Form in Excel -
Read Filtered Cells
Allow read only cells filters -
Count Filtered Cells
Allow count only cells filters -
Replace
Run replace action to excel -
Order
Run replace action to excel -
Refresh All
Refresh all data in Excel -
Find
Return de first found cell -
Lock Cells
Lock or Unlock cells -
Add Chart
Create a new chart in an excel sheet -
Remove Password
Remove password and save the Excel -
Insert image
Insert an image -
Export Chart
Export a chart from index -
Not visible mode
Open not visible excel. -
Write array objects
Write array object on Excel cells. -
Copy-Paste Format
Copy format range cell to another sheet -
Find and Connect
Search a Excel Book opened and connect it -
Update links
Changes a link from one document to another -
Unlock sheet
Unlock sheet -
Convert to .txt
Convert to .txt -
Text to columns
Parses a column of cells that contain text into several columns. -
Convert Excel time to hours
Convert Excel time to hours. Returns the format as hh: mm: ss -
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