Delete row(s) directly from Excel sheet

Help
1

Hi, how do I delete rows directly from the Excel sheet? I.e. I want the rest of the rows to move upwards if I delete it and not just erase its contents. Is there any way to do this without reading the sheet into a DataTable? Because the data is quite messy and I am relying on Excel rows and column locations to find values. I am using UiPath 2017 version and I don’t see any default activity to do this.

2

Use the Delete Range activity.
On the properties, check Shift Cells and choose ‘ShiftUp’ in the ShiftOption Property

2 Likes
3

Hi, my version of UiPath does not have this activity. Is there another way to do this?

4

@DEATHFISH, Please install UiPath.Excel.Activities Version 2.4.6856.17931 or the latest version 2.5.2 (as of today) to use the DeleteRange activity https://activities.uipath.com/docs/release-notes-excel#section-uipath-excel-activities-v2-4-6856-17931

How to install packages?

Please refer the below link:

5

I am trying to update Excel package but it says unable to resolve dependency System.Configuration.ConfigurationManager (>= 4.5.0)

How do I resolve this?

6

Could you please check if the Official feed is configured in the studio?

image
image810×188 8.76 KB

Alternatively, you can also download the System.Configuration.ConfigurationManager package from the link: NuGet Gallery | System.Configuration.ConfigurationManager 6.0.1
and place it in any of the configured feeds like C:\Program files(x86)\UiPath\Studio\Packages folder.