I could not understand why this happens
Page 1 / 1
Hi
The excel you are currently using might had data till 1841 and later on you might have just deleted the data not the whole rows.
Please find below two approaches:
- Manually remove the blank rows.
- Apply If condition on a specific column for not blank condition inside the excel loop:
- Loop(excel rows){
- If ( CurrentRow{“column name”} =! blank){
- Increment RowCounter
- }
- }
- If ( CurrentRow{“column name”} =! blank){
- After the loop has finished you can use the RowCounter as number of rows.
- Loop(excel rows){
- Let me know whether the condition works or not
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.