Excel Commands
In this chapter:
Which Excel versions are supported?
As a general rule, Nintex supports desktop (i.e., non-mobile) versions of Excel that are within Microsoft's Mainstream Support or Extended Support periods. Currently, this includes Excel 2010 and higher. For additional details, see Microsoft Lifecycle Policy (Excel)on the Microsoft support website.
Do you need to have excel installed to use the commands?
You need to have Excel installed only if you are using the "Run Macro" command, and if you are using "select range" in "Copy from Excel" and "Paste to Excel" commands.
Refer to the table below for a detailed overview of each command and its respective functionalities:
| Command | Description |
|---|---|
|
Convert a single worksheet from an Excel file to CSV format and save it in the specified location. |
|
|
Copy the specified cell values from an Excel file and store them in a new or existing variable. |
|
|
Create a new Excel file in the location and with the file name you choose. |
|
|
Delete specified cell values from an Excel file. |
|
|
|
Retrieve the number of columns within a specified row and place it into a new or existing variable; or insert or delete columns |
|
Retrieve the number of rows within a specified column and store it into a new or existing variable; or insert or delete rows. |
|
|
|
Retrieve information about the worksheets within an Excel file and store it in a new or existing variable.; or perform basic worksheet actions (rename, move, delete, etc.) |
|
|
Paste value(s) or formula(s) into an existing Excel file. |
|
Query an Excel worksheet using SQL to return specific values from a range or entire sheet. |
|
|
|
Run a VBA macro on the specified Excel file. |