How to delete Last Row in excel with dynamic Range?

W_QW · January 14, 2019, 1:24pm

reda · January 14, 2019, 2:45pm

The easiest way to get the last row and delete it in an excel sheet is by using the UiPathTeam.excel package you will find in manage packages like the image below :

After that you just need to get the number of the last row and then point on it and then delete it this way you can dynamically delete the last row :

You will find everything in the following zip file :

Decompress it under Documents\UiPath and you should be good to go

DeleteLastRowExcel.zip (16.6 KB)

This is the easiest way because you don’t have to deal with DataTables or anything.

Regards,
Reda

rahatadi · January 14, 2019, 2:41pm

Hi @W_QW

Read whole excel store output in datatable

LastrowNumber = Datatable.rows.count+1

Now you can delete dynamically

the.christopoulos · October 29, 2019, 8:42am

@rahatadi With which command can I delete dynamically after assigning the lastrownumber ?

sarathi125 · October 29, 2019, 10:34am

Use Insert/Delete Activity from that extensions list

the.christopoulos · October 29, 2019, 1:48pm

Thank @sarathi125

minal.patil · December 16, 2020, 5:27am

How to delete last three(3) rows in excel