Excel Functions
Last Updated: Mar 15, 2021
Last Updated: Mar 15, 2021
The following functions can be used for operations in Excel:
Before executing, the file on which this function needs to be performed must be opened using the Open Excel File function.
| Functions | Description |
|---|---|
| Apply Filter | Applies the given filter on the input column of the input table present in the active sheet |
| AutoFill | Takes the formulas defined in the specified rule range and adapt them to the specified end range |
| Clear Filter | Removes the filters applied in the specified table |
| Clear Range | Clears data in a specific range of cells |
| Close Excel | Closes the active excel application |
| Close File | Closes the excel file present in the specified path |
| Close Workbook | Closes the active workbook |
| Convert Column Letter To Number | Converts the column letter to a number |
| Convert Column Number to Letter | Converts the specified column number to a letter |
| Copy & Paste | Copies the content from the given source sheet-range and Pastes it in the destination sheet-range based on the paste-type given as an input |
| Copy Entire Data | Copies the values and metadata from the given input range and provides the output in an XML format |
| Copy Entire Data as Table | Copies the values and metadata from the given input range and provide output according to the input table definition |
| Copy To Clipboard | Copies the input range to the clipboard |
| Copy Values | Copies the values from the input range and provides the output in an XML format |
| Copy Values As Table | Copies values (without metadata) to a data table from the specified range of the currently active excel sheet |
| Copy Values As Table (Dep.) | Copies values (without metadata) to a data table from the specified range of the currently active excel sheet |
| Copy Values As Table From A Sheet | Copies values (without metadata) from the specified range of the given excel sheet to a data table |
| Create Sheet | Creates a new sheet in the current workbook |
| Create Table | Creates a table in the sheet with a given range and table name |
| Delete Column | Deletes the column of the specified column letter in the workbook |
| Delete Range | Deletes a specific range of cells in the workbook |
| Delete Row | Deletes a specified row from the workbook |
| Delete Sheet By Index | Deletes the sheet from the workbook using the specified index |
| Delete Sheet By Name | Deletes the sheet from the workbook using the specified sheet name |
| Get Cell Color | Extracts the color of the cell |
| Get Cell Value | Gets the value of the specified cell as text |
| Get Last Cell with Data | Gets the address of the last cell that has data |
| Get Last Column with Data | Gets the last column that has data |
| Get Last Row And Column with Data | Gets the address of the last row and column that has data |
| Get Last Row with Data | Gets the last row that has data |
| Get Table Range | Retrieves the excel range of a table from the active spreadsheet |
| Get XML Format of Cell | Retrieves the Excel XML notation of the cell with the given row, column, and value. |
| Insert Column | Inserts a new column at the specified position |
| Insert Row | Inserts a new row at the specified position |
| Is Sheet Exists | Checks if the sheet exists or not in the workbook |
| Lookup Range | Checks if a value exists in the specified range and returns the address of the cell where the value exists |
| Open Excel File | Opens the file specified in the path |
| Open Protected Excel | Opens password protected .xls, .xlsx, .xlsm, .csv files |
| Paste Entire Data | Pastes the values along with properties like font, color, etc. from the given input XML |
| Paste MetaData From Clipboard | Pastes the values along with properties like font, color, etc. from clipboard to the specified cell range |
| Paste Table Data | Pastes the values from the table variable to a range starting from the specified cell |
| Paste Values | Pastes the values from the output XML of the Copy Value function |
| Paste Values From Clipboard | Pastes the values from the clipboard to the input range |
| Read Formula | read the cell formula from the input cell address |
| Refresh Pivot Table | Refreshes the specified pivot table in the active worksheet |
| Remove Duplicate Rows | Deletes all the rows that are duplicated in a specified range and return the number of rows remaining in the range |
| Remove Macro | Removes the macro with the given name if it exists |
| Rename Sheet By Index | Renames the sheet at the specified index to the specified new name |
| Rename Sheet By Name | Renames the sheet with the specified existing name to a specified new name |
| Run Macro | Runs the macro with the specified name |
| Save | Saves the workbook with the changesd |
| Save As | Saves the content as new file provided in the input file path |
| Select Sheet By Index | Selects the sheet in the workbook using the input index |
| Select Sheet By Name | Selects the sheet in the workbook using the specified sheet name |
| Send keys | Sends the key combination to the file to perform the required actions |
| Set Color to Range | Applies the color of the specified RGB value to the specified range of cells |
| Sort Table Data | Sorts the table using column name and sort order |
| Update Cells | Updates the specified range of cell(s) with the specified value |
| Write Formula | Writes the specified cell formula to the specified range |