cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete Top 10 rows from Excel

MohiniShelke
Level 4
Hello All, 
I want to delete Top 10 rows from Excel and get it into new excel. 

I don't want these in collection because we have around 20000 data in Excel, And collection will take more time to write data into Excel. 

Please let me know the solution for this if anyone knows. 


Thanks in advance

------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------
11 REPLIES 11

Hi, Adarsh,

I did a simple test see attached document and it works without any issue (only D1:D3). Could you use Show action in your process so that you can see that the selected cells are highlighted? I tested even with "D:D" range and it deleted the content of whole column.

Regards,

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

​Thank you Mr.Zdeněk for the screenshots.

I will try this approach.


------------------------------
Adarsh Kappettu
------------------------------