I could not understand why this happens
Why ExcelAdvanced:Go to cell(end of column of current cell) goes to 1831.row even though there are 641 rows? only
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.