cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete rows in an excel file using SAP IRPA?

0 Kudos

I want to delete duplicate entries in an excel file. I have written the code to find the index of duplicate entries and now I am stuck at the point where I am unable to delete the entries. I couldn't find a method on the contextor page ar any other site.

Accepted Solutions (0)

Answers (1)

Answers (1)

yogananda
Product and Topic Expert
Product and Topic Expert

Hi krishna_c_singh91

you need to use excel extension and sharing below link to get you an idea on how to delete the rows or you can refer other extension to acheive your solution

https://help.sap.com/viewer/dbe2687952b8433a953c6b6305429122/Cloud/en-US/2f1764590ff248a9b36c58a82ad...

ctx.excel.sheet.deleteRange( 'B:B' );