How to Delete the last three rows in Power Automate Deskop

(0) Share

Report

Posted on by TTC Super User 2024 Season 1

Hello,

Can someone please help me on how to delete the last three rows in PAD? I've tried everything (-1, -2, and -3) nothing seems to work.

I have other excel file that the delete work, but it does not work on this file. I am wondering why? I am guessing it's because the grand total is not on row 90? This is how I got the file from the customer, but I need PAD to treat it and delete the last 3 rows.

Thank you an advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report
@TTC

Please follow the below approach.
Launching Excel and opening a specific file
Reading data from Excel
Determining the number of rows in Excel data and add one into it for header
Looping to delete rows for three time and delete the last rows each time

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Boot\\Invoice.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData SET ExcelRowscount TO ExcelData.RowsCount + 1 LOOP LoopIndex FROM 1 TO 3 STEP 1 Excel.DeleteRow Instance: ExcelInstance Index: ExcelRowscount SET ExcelRowscount TO ExcelRowscount - 1 END

How to copy and paste the above code into your desktop flows?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
TTC Super User 2024 Season 1 on at

Like (0)

Report

Thank you so much!

Was this reply helpful? Yes No