Insert row to Excel worksheet Action(Power Automate Desktop)


Japanese version.

Action to insert a new row into an Excel worksheet.

BGM. Music by

How to use.

Specify the target file in Launch Excel Action or Attach Running Excel Action and drag Insert row to Excel worksheet Action from Excel to the Workspace.

Set parameters.


Excel instance

Specify the target Excel file.

Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.

Row index

Add one row above the row index.

If the file has more than one sheet, it is not clear which sheet is active.
Specify the sheets in the Set active Excel worksheet Action first.

For example, specify a row index of 2 for the following book

When the action is executed, one line is inserted on the second line.

Variables produced

Not present in this Action.

On error

Error handling is performed as needed.



Excel Actions.

Examples of Use

Insert empty rows in Excel worksheet, one row at a time.