Excel(Power Automate Desktop Action)
This function is related to Excel operation.
It launches the installed Excel, reads and writes data, etc.
Contents
Actions
Name | Importance | Description |
---|---|---|
Launch Excel | High | Open or create a new Excel file to be manipulated. To operate Excel with Power Automate Desktop, this Action or Attach to running Excel Action must be performed first. |
Attach to running Excel | Middle | Specify an already opened Excel file as the target of the operation. To perform an Excel operation with Power Automate Desktop, either this action or Launch Excel Action must be performed first, although Launch Excel Action is more common in practice. |
Read from Excel worksheet | High | Extract values from an Excel book by specifying a cell or range of cells. |
Get active cell on Excel worksheet | Middle | Get the currently selected cell position (number of rows and columns). |
Save Excel | Middle | Save the edited Excel file without closing it. |
Write to Excel worksheet | High | Set values in an Excel file by specifying a cell or range of cells. |
Close Excel | High | Closes an Excel file that has been manipulated by Power Automate Desktop. You can also save the file. |
Set active Excel worksheet | High | Change the active (selected) sheet by specifying the sheet name or index. This is a frequently used action because many actions target the active sheet. |
Add new worksheet | ||
Get first free column/row from Excel worksheet | High | Retrieves rows or columns with no data. This action is often used before an action that manipulates data to determine the position to be manipulated. |
Get column name on Excel worksheet |
Advanced
Name | Importance | Description |
---|---|---|
Resize column/rows in Excel worksheet | ||
Run Excel macro | ||
Activate cell in Excel worksheet | Low | Makes a single cell active (selected). Specify the column/row or the distance from the current position. This is a simpler way to specify the cell position in each action than to use this, so it is not necessary to specify the cell position in each action. For this reason, it will often be used for macros and other circumstances outside of Power Automate Desktop. |
Select cells in Excel worksheet | Low | Makes cell range active (selected). Specify the column/row or the distance from the current position. This is a simpler way to specify the cell range position in each action than to use this, so it is not necessary to specify the cell position in each action. For this reason, it will often be used for macros and other circumstances outside of Power Automate Desktop. |
Get selected cell range from Excel worksheet | Low | Obtains the number of first columns/rows and last columns/rows in the active (selected) cell range. |
Copy cells from Excel worksheet | Middle | Specify a cell or range of cells to copy. The copied content is pasted using Paste cells to Excel worksheet. |
Paste cells to Excel worksheet | Middle | Specify the cell location and paste the contents copied in Copy cells from Excel worksheet. |
Insert row to Excel worksheet | High | Add an empty row above the specified row. |
Delete row from Excel worksheet | High | Delete one row from the Excel worksheet. |
Insert column to Excel worksheet | Middle | Add an empty row column the specified column. |
Delete column from Excel worksheet | Middle | Deletes a column by specifying the number of columns. |