Clear Datatable not working

Help Studio
21

FLM.xaml (6.8 KB)

Seems like everything is going on right…

I have used a message box and it shows everything is cleared except the header

1 Like
22

@Sweety_Girl if i execute in excel file, i do not see the results using write range activity.

Will you able to get the same results in excel file i.e. everything cleared except headers.

23

FLM (1).xaml (7.5 KB)

@Raj_Nadar

I have added a empty row using add data row… and wrote in excel…

It works… try it

24

we do not want add rows, just clear entire rows after headers, i tried as not getting desired resultsTestfile.xlsx (10.9 KB)

FLM.xaml (7.0 KB)

25

Do u need to write in that same excel

26

@Raj_Nadar I guess you need to use Delete Rows Activity inside Excel Application Scope with Position as 2 and No. of rows as the DT.Rows.Count

27

Yes, same table we wanted to clear except header

28

U can use this Clear sheet VBA code and then use write range activity,

VBA code,

Sub ClearEntireSheet()
Sheets(“Sheet1”).Cells.ClearContents
End Sub

29

1.I think if your datatable is not having any rows and you try to write range it … You will not get anything.
You can try by putting one sample row and verify above point.

If you want only One row of data , using the Build DataTable I can insert one Row with the Data Required (Header and Data can be Same) and then in Write range - I can write DataTable Without Header

image
image902×418 13.3 KB

image

  1. We can have a below logic in place

  2. we can create 2 DataTable - one with only Header - dtHeader

  3. other with Header and one Row of Data (Same as Header) as shown in above threads -dtHeaderRow

3.Then we use an - IF Statement here and Checking the Datatable row count.

  1. If DT.rows.Count < 1 - That means DT is empty - we write range the dtHeaderRow
    else
    we write Range the dtHeader

–
Mukesh

1 Like
30

If one wants to delete excel rows, using an empty Data Table to write back (overwrite) the excel will never work as UiPath will see it is an empty table and not do anything with it…

2 Likes
31

I think that you will just want to use “Filter Data Table” instead of “Clear Data Table”. It sounds weird, but if you set it to filter to “Keep” something that it will never find, it will always just return the headers without any of the data.

For example, I set it to Keep a row only if it is and is not empty so it automatically just leaves the header:

image