excel有空行，但是处理的时候遇到空行就停下了，这个要如何解决，我需要把所有的非空行都处理掉
Hi @ruiang
You are having few blank lines in between the rows and the robot stops in the blank line is that right?
Regards
Sudharsan
yes
If the blank lines in the excel is not needed
you can remove the blank lines by using filter datatable activity by giving
“pId” isEmpty as condition and click on remove and rewrite in the shame sheet or new sheet and use it for process
Regards
Sudharsn
there is no way that don’t need to do a filter？
I think that is a bug ,UiPath can use Range(Col & “1048576”).End(xlUp).Row to fix it
Hello,
我看了下上面的Excel，你可以按照这个思路考虑下：
1）要处理的Excel数据哪一列的内容，你是不希望它的内容为空的
2）遍历读出来的DataTable时，在里面加一个If进行该列内容是否为空的判断
3）如果为空，你希望跳到后面行去处理，在IF里面加一个Continue 组件就好了；如果为空，你想停止后面的处理的话，选择Break组件就好了。