Site icon Kaizen.Personal computer work.

Insert row to Excel worksheet Action(Power Automate Desktop)

Japanese version.

Action to insert a new row into an Excel worksheet.

BGM. Music by mubert.com

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.

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.

---

Links

Excel Actions.

Examples of Use

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

Exit mobile version