Help Centre › Building Processes
Description
This article provides an overview of the EXCEL functions available in RPA. These functions allow you to perform various operations on Excel workbooks, such as reading and writing data, manipulating sheets, and more.
Available EXCEL Functions
- Add a password
- Add a password to a sheet
- Add hyperlink
- Add named range
- Add note
- Add a row
- Add chart
- Add columns
- Add image
- Add pivot table
- Add sheets
- Add table
- Autofill columns
- Autofit columns
- Bring Excel to the front
- Find closest match
- Column unique values
- Change column values
- Clear a cell / range
- Conditional format
- Clear a cell / range's validation
- Click / select a cell
- Convert a sheet to a PDF
- Copy a cell / range
- Copy multiple cells / ranges
- Copy column
- Copy rows
- Copy a sheet
- Ensure columns exists
- Ensure sheet exists
- Enter a formula
- Execute a function
- Extract data
- Find duplicates
- Find a value
- Find / replace values
- Flatten formulas
- Format cells
- Freeze panes
- Find values using a pattern
- Get a cell's validation
- Get hyperlink
- Get named range value
- Get note
- Go to first cell
- Go to first column
- Go to first open row
- Go to first row
- Go to last cell
- Go to last column
- Go to last row
- Hide all sheets
- Hide columns
- Hide sheet
- List named ranges
- List tables
- Lookup column values
- Merge cells
- Move
- Paste data from memory
- Paste into a cell / range
- Paste into multiple cells / ranges
- Paste invoice data
- Paste MT940 data
- Paste column
- Paste rows
- Paste sheet
- Press keys
- Remove a password
- Remove a password from a sheet
- Reconcile
- Remove blank rows
- Remove columns
- Remove duplicates
- Remove filters
- Remove hyperlink
- Remove image
- Remove named range
- Remove note
- Remove a pivot table
- Remove rows
- Remove sheets
- Remove table
- Rename a sheet
- Rename columns
- Run a macro
- Save
- Save as
- Save as PDF
- Select a range
- Select a sheet
- Set a cell's validation
- Set background color
- Sort
- Sort columns
- Text to columns
- Test if a sheet exists
- Test if a column exists
- Unfreeze panes
- Unhide all sheets
- Unhide columns
- Unhide sheet
- Unmerge cells
- Update row values in a loop
- Write
- Write in multiple cells