Skip to main content

I could not understand why this happens

Hi @Semih 3318 ,

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
        • }
      • }
    • After the loop has finished you can use the RowCounter as number of rows.
  • Let me know whether the condition works or not
 

Reply