Search

Excel Functions

Last Updated: May 10, 2022

Articles

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, such as font, color, etc. from the given input XML
Paste MetaData From Clipboard Pastes the values along with properties, such as 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

See Also

Did you find what you were looking for?