Excel(Power Automate Desktop Action)

03/21/2023

Japanese version.

This function is related to Excel operation.
It launches the installed Excel, reads and writes data, etc.

Actions

NameImportanceDescription
Launch ExcelHighOpen 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 ExcelMiddleSpecify 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 worksheetHighExtract values from an Excel book by specifying a cell or range of cells.
Get active cell on Excel worksheetMiddleGet the currently selected cell position (number of rows and columns).
Save ExcelMiddleSave the edited Excel file without closing it.
Write to Excel worksheetHighSet values in an Excel file by specifying a cell or range of cells.
Close ExcelHighCloses an Excel file that has been manipulated by Power Automate Desktop. You can also save the file.
Set active Excel worksheetHighChange 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 worksheetHighRetrieves 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

NameImportanceDescription
Resize column/rows in Excel worksheet
Run Excel macro
Activate cell in Excel worksheetLowMakes 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 worksheetLowMakes 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 worksheetLowObtains the number of first columns/rows and last columns/rows in the active (selected) cell range.
Copy cells from Excel worksheetMiddleSpecify a cell or range of cells to copy. The copied content is pasted using Paste cells to Excel worksheet.
Paste cells to Excel worksheetMiddleSpecify the cell location and paste the contents copied in Copy cells from Excel worksheet.
Insert row to Excel worksheetHighAdd an empty row above the specified row.
Delete row from Excel worksheetHighDelete one row from the Excel worksheet.
Insert column to Excel worksheetMiddleAdd an empty row column the specified column.
Delete column from Excel worksheetMiddleDeletes a column by specifying the number of columns.