Insert empty rows in Excel worksheet, one row at a time.(Power Automate Desktop)

03/18/2023

Japanese version.

Introduce a Flow to insert blank lines one at a time.

Overall view of Flow

Robin(for copy and paste)

It can be copied and pasted into Power Automate Desktop.

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Test\\Test.xlsx''' Visible: False ReadOnly: False Instance=> ExcelInstance
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow
LOOP LoopIndex FROM FirstFreeRow TO 3 STEP -1
    Excel.InsertRow Instance: ExcelInstance Index: LoopIndex
END
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance

Flow creation steps

Set up a Launch Excel Action.

ParameterValue
Launch Exceland open the following document
Document pathPath of the target Excel book.
Make instance visibleOFF
Open as ReadOnlyOFF

Set up a Set active Excel Worksheet Action.

ParameterValue
Active worksheet withName
Worksheet nameThe name of the target sheet.

Set up a Get first free column/row from Excel worksheet Action.

Set up a Loop.

Add rows from the top, because the number of rows changes and it doesn't work properly. Therefore, we will add rows from the bottom.

ParameterValue
Start from%FirstFreeRow%
End to3
Increment by-1

Set up a Insert row to Excel worksheet Action in Loop.

ParameterValue
Row index%LoopIndex%
「Excel ワークシートに行を挿入」のパラメーター設定

Finally, set up Close Excel Action and save the file.

ParameterValue
Before closing ExcelSave document
「Excel ワークシートに行を挿入」のパラメーター設定

Executing this flow inserts one blank line at a time.

Before flow execution.
After flow execution.

---