How to keep moving if details in Excel is empty?

Help Activities
1

Dear Friends

There are some preparation at the beginning of my process

If there are details in the excel(sample1), then clear range(A2:H3), keep the headers
I know how to do it for this part

Sample1

image
image1016×92 8.74 KB

If there is no detail in the excel(sample2), then continue to move on the following process
If I do nothing to modify my current process, there will be error pop up and process stop here

Sample2

image
image1019×110 4.99 KB

PS: Sample1 and Sample2 are same excel file. The reason it could be no detail in it is that the detail are captured from relative emails. But sometime there will be no email to handle then it will be empty the next time UiPath open it

Thank you for your kind guidance as always

Regards
Ivan

2

You can use a read range activity to check if there are values on the excel file.

If (dt.rows.count > 0)
Proceed to delete the rows
else if (dt.rows.count = 0)
do nothing

3

Thank you for the prompt reply
But I don’t know why UiPath keep outputing “14” while I only have header in the file

image
image1021×499 8.29 KB

image
image651×839 23.9 KB

image

1 Like
4

Hi @yangyq10

Print datatable in excel. If you clear filter from input excel, maybe you can see 14 rows of data.

Thanks

5

Thank you for the feedback
I already clear the filter and there is no detail under each column
But somehow it still output “14” after test run
No idea what causes this

image
image1035×368 7.08 KB

1 Like
6

Try to delete row 2 to 15

7

Hi @yangyq10

If possible, can you please share the input file.

Thanks

8

Thank you for your support
Pls check the file I am using for the process
JACCS.xlsx (10.4 KB)

9

Hi ,
you can check if the excel is empty or not by giving a condition :

dt_table.Rows.Count = 0

image

10

I tried to use the file andthe rows.count is outputting zero

image

11

Thank you. I finally know the root cause is that I use [Clear Range] but not [Delete Rows] previously which cause row record in the file.

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.