Answered

Delete Row From Excel Worksheet

(0) Share

Report

Posted on by KaiHalpin

Good Morning,

I was having trouble when running my code regarding the Delete Row from Excel Sheet Function. I have certain keywords in my data, and if the row contains this key word I need to delete it. I have used the Find and replace cells in Excel Worksheet Function to find all of my keywords and change them to the word delete. I then find all cells with the text delete and store them on a separate table. However, I am unsure on how to actually use the Delete Row from Excel Worksheet function to delete all of my desired Rows. Any help is appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @KaiHalpin ,

Please find the solution.
Note: For Data I have created a DataTable.

Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Excel\\Input\\0048600218_2024-APR-U002M204.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Variables.CreateNewDatatable InputTable: { ^['Input'], [$'''D55'''], [$'''U432'''], [$'''U433'''], [$'''U435'''], [$'''U435'''] } DataTable=> DataTable LOOP FOREACH CurrentItem IN DataTable Excel.FindAndReplace.FindSingle Instance: ExcelInstance TextToFind: CurrentItem MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Rows FoundColumnIndex=> FoundColumnIndex FoundRowIndex=> FoundRowIndex Display.ShowMessageDialog.ShowMessage Message: FoundRowIndex Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed IF FoundRowIndex <> 0 THEN Excel.DeleteRow Instance: ExcelInstance Index: FoundRowIndex END END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@KaiHalpin

Please follow the below approach:

Code:

Variables.CreateNewDatatable InputTable: { ^['Column1', 'Column2'], [$'''Metered Raye''', $''':1000'''], [$'''Tubing Pressure''', $''':495'''], [$'''Mechanical Loss''', $''''''], [$'''Interval Type: Interval %% Loss Remarks''', $''''''], [$'''______________________________________''', $''''''], [$'''1420 - 1503 PERI 1450 - 1490 77%%''', $''''''], [$'''1580 - 1561 PERI 15200 - 1561 23%%''', $''''''], [$'''Lower B''', $''''''], [$'''______________________________________''', $''''''], [$'''Metered Rate''', $''':650 B/D'''], [$'''Tubbing Pressure''', $''':570 PSI'''] } DataTable=> DataTable Variables.FindOrReplaceInDataTable.FindItemInDataTableByColumnIndex DataTable: DataTable AllMatches: True ValueToFind: $'''__''' MatchCase: False MatchEntireCellContents: False ColumnNameOrIndex: 0 DataTableMatches=> DataTableMatches SET StartRow TO DataTableMatches[0][0] Text.ToNumber Text: StartRow Number=> StartRowAsNum SET StartRowAsNum TO StartRowAsNum + 1 LOOP LoopIndex FROM 1 TO StartRowAsNum STEP 1 Variables.DeleteRowFromDataTable DataTable: DataTable RowIndex: 0 END Variables.FindOrReplaceInDataTable.FindItemInDataTableByColumnIndex DataTable: DataTable AllMatches: True ValueToFind: $'''Lower''' MatchCase: False MatchEntireCellContents: False ColumnNameOrIndex: 0 DataTableMatches=> DataTableMatches SET EndRow TO DataTableMatches[0][0] Text.ToNumber Text: EndRow Number=> EndRowAsNum SET EndRowAsNum TO EndRowAsNum LOOP LoopIndex FROM EndRowAsNum TO DataTable.RowsCount STEP 1 Variables.DeleteRowFromDataTable DataTable: DataTable RowIndex: EndRowAsNum END

How to copy/paste the above code in your power automate desktop?

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
KaiHalpin 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response, but it didn't apply to my situation. I have a table like this (see attached image) where I have the rows that I need to delete stored in a table. All of the values in the column that is labelled Row Index are the numbers of the rows that I need to delete on my Excel Sheet. I need a way to delete all of these values that are on the spreadsheet itself.

Edit: Resolved

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@KaiHalpin

You can follow the below approach:

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
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KaiHalpin ,

Did you tried my solution,just try and let me know.

Regards,
Vishnu Reddy

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KaiHalpin !

@KaiHalpin wrote:

Thanks for the response, but it didn't apply to my situation. I have a table like this (see attached image) where I have the rows that I need to delete stored in a table. All of the values in the column that is labelled Row Index are the numbers of the rows that I need to delete on my Excel Sheet. I need a way to delete all of these values that are on the spreadsheet itself.

You could just use a for each loop and loop through this datatable and grab the 2nd column (index will be 1) and use the action "Delete row from Excel worksheet" to achieve your requirements.

I hope this helps.

Was this reply helpful? Yes No