Excel Automation
Genzbots provides 18 Excel activities covering every common operation — read/write ranges, cell formulas, formatting, sorting, filtering, sheet management, macros, and VBA execution. All Excel activities run inside an Excel Application Container that manages the COM session.
Excel Application Container
The container opens (or creates) a workbook and scopes all child Excel activities to it.
| Parameter | Description |
|---|
| File Path | Path to the .xlsx / .xls / .xlsm file |
| Visible | Show the Excel window during automation (useful for debugging) |
| Create If Missing | Create the file if it does not exist |
| Password | Open password-protected workbooks |
| Save On Complete | Auto-save when the container block finishes |
One container per workflowOpen the workbook once per workflow — do not put the container inside a loop. All read/write activities inside the container share the same COM instance.
Read & Write
| Activity | What it does |
|---|
| Excel Read Range | Reads a cell range (e.g., A1:D100) into a DataTable. Leave range empty to read the used range. |
| Excel Write Range | Writes a DataTable to a starting cell (e.g., A1) |
| Excel Get Cell Value | Reads a single cell into a variable |
| Excel Set Cell Value | Writes a value to a single cell |
| Excel Get Formula | Returns the formula string from a cell (e.g., =SUM(A1:A10)) |
| Excel Set Formula | Sets a formula in a cell |
| Excel Save Workbook | Saves without closing the container |
Sheets
| Activity | What it does |
|---|
| Excel Get Sheet Names | Returns all sheet names as a StringArray |
| Excel Add Sheet | Inserts a new sheet with a given name |
| Excel Delete Sheet | Removes a sheet by name |
| Excel Rename Sheet | Renames an existing sheet |
Formatting, Filtering & Sorting
| Activity | What it does |
|---|
| Excel Format Range | Apply bold, italic, font size, background colour, borders to a range |
| Excel Auto Filter | Apply or clear AutoFilter on a range |
| Excel Sort Range | Sort a range by one or more columns (ascending/descending) |
Macros & VBA
| Activity | What it does |
|---|
| Excel Run Macro | Run an existing macro by name (workbook must be .xlsm) |
| Excel Add Macro | Insert VBA code into the workbook programmatically |
| Excel Execute VBA | Execute arbitrary VBA code as a string |
