Delete range

Help
1

Hey,

I need to delete all excel lines.

Can you help me ?

Capturar
Capturar1385Ă—679 79.2 KB

2

@Renan_Pereira

  1. First use Read Range activity to read excel file and will give you output as DataTable.

  2. int Count = yourDT.Rows.Count

  3. Then use Insert/Delete Rows activity and pass that count value into NoRows field and position as 0.

1 Like
3

You can use delete range activity to do that @Renan_Pereira

4

Yes, how do I use delete range?

Capturar1
Capturar1961Ă—462 12.9 KB

5

You can provide the range which you want to delete in the excel sheet.

7

Specify the range you want to delete and the sheet name.

If you don’t know the range or the number of rows, use read range and store the data in datatable. then you will get the number of rows using datatable.rows.count and store in a variable (assume count) and then specify the range as “A2:Z” + count.tostring which will delete entire rows except the headers

2 Likes
8

Hi Iakshman, unfortunatelly this does not work in my project.

I want to delete all Values (and empty cells) in the column “A”

Thanks in advance!

9

@aaydin

Welcome back to our UiPath community.

Use Filter DataTable activity or below select query to filter all empty rows based on column A.

                          dtNotNullRows = inputDT.Select("[Column Name] is Not Null").CopyToDataTable

And then write this dtNotNullRows DataTable into new sheet and then delete previous existing sheet.

10

@lakshman

I have created as per below (screenshots)

I want just delete all values in a specific column.

But something in “Insert/Delete Rows” activity does not work.

Is it really so difficult?

Thanks in advance!

strong text

Screenshot1
Screenshot1646Ă—706 36.3 KB
Screenshot2 Screenshot3 Screenshot4

11

Could you not just delete the column and then add it again?

12

It does not work, I have already changed the ChangeMod in Insert/Delete Rows acitivity in Remove. But nevertheless, there are no changes in the list :slight_smile:

13

@lakshman any idea? :slight_smile:

15

Check this article, maybe it will help you: https://uipath-survey.secure.force.com/CaseView/articles/Knowledge/How-to-use-Delete-Rows-activity-for-Studio-and-StudioX-profiles