Hi Folks, I need to use Delete Row Activity to delete 180th(for example but dynamic in real scenario) index from the Excel File. What should be the input in Specific Row to suffice this condition and successfully delete the row. Screenshot of error [image]

Hi, If we set Range(“B7”) in DeleteRows activity, it works for only the 7th row. If we need to delete the 180th row, we need to set Delete.Sheet("name").Range("B7:B200") for example or Delete.Sheet(“name”).Range(“B:B”) then set position considering offset. [image] Regards,

Unable to delete row on a specific index using Delete Row Activity

Help Activities

Yoichi (Yoichi) August 28, 2023, 1:15pm 5

Hi,

There are some ways to achieve it. One of them, can you check the following post? This removes target rows in bulk after ForEach loop.

Regards,

Topic		Replies	Views
Delete range Excel from specific cell onwards Activities uiautomation , activities , question	9	192	March 1, 2024
How to delete row using row index Studio	6	1146	July 13, 2022
Delete range only working once Studio excel , activities	4	995	March 14, 2020
How to delete particular row in excel Activities excel , studio	14	5843	September 22, 2023
How to delete specific rows from excel file Learn studiox	9	1656	June 25, 2020

Most Active Users - Yesterday
Anil_G
ashokkarale
Yoichi
Jon_Smith
A_Learner
ewanc1
Sylvain_FARNAULT_131
CHEN-CC
Eric_Alvarado
azeem_rosli
More details...

Unable to delete row on a specific index using Delete Row Activity

Related topics