How to delete Last Row in excel with dynamic Range?

Build
#1

How to delete Last Row in excel with dynamic Range?

Delete range only working once
#2

Hi @W_QW

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 :

image
image.png1274×526 22.8 KB

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 :

image
image.png454×575 9.04 KB

You will find everything in the following zip file :

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

DeleteLastRowExcel.zip (16.6 KB)

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

Regards,
Reda

1 Like
#3

Hi @W_QW

Read whole excel store output in datatable

LastrowNumber = Datatable.rows.count+1

Now you can delete dynamically :slight_smile:

1 Like
#4

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

#5

Use Insert/Delete Activity from that extensions list

1 Like
#6

Thank @sarathi125