Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

how to delete first 10 rows?

Hello Team,


I have an excel and want to delete first 10 rows, how to do that?


I can delete only 1 row at a time.


Thanks

Vaibhav


Best Answer
You will always want to delete row 1 in your loop 10 times ( or delete row 2 if you jave header row in row 1 that needs to remain) because when delete row excel action is execute your existing rows move up 1 row.

ADMIN

Hello Vaibhav,


Using loops, delete each row from your excel instance. Below is the screenshot for your reference:


image


I hope it helps.



1 person likes this

Thanks @Shalini .


Sorry if I may ask 1 more question as i have started to use Winautomation.


how to check for the last blank row and delete until then?

ADMIN

Hello Vaibhav.


We have an action "Get First Free row/column from Excel Worksheet". This gives the last blank row & column from the active worksheet.


Below is the manual guide for your reference:

https://docs.winautomation.com/index.html?lang=en 


I hope it helps.


1 person likes this

Thanks!



1 person likes this
Answer
You will always want to delete row 1 in your loop 10 times ( or delete row 2 if you jave header row in row 1 that needs to remain) because when delete row excel action is execute your existing rows move up 1 row.

2 people like this
Login or Signup to post a comment