(CurrentDay = row(4).ToString.Split("-"c)(0)) and (CurrentMonth = row(4).ToString.Split("-"c)(1))

Hi first run its working for second run its giving error like "If: Index was outside the bounds of the array."

Hy @Damodara_Rao_Punugubati,

This error means that one of your split methods failed to find the item you were searching.

I suggest you use the ‘write line’ to print to the output window the text of column 4, so you can better take a look at the issue.


Hi @Damodara_Rao_Punugubati

Can you show the data fields on excel.
And tell that actually what you are trying to do with it

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

yes i had some empty cells , how i can overcome this issue .


place a if condition for checking empty rows

row(4).Tostring <> “”


1 Like

Hy @Damodara_Rao_Punugubati,

to overcame this you can use the len(row(4).toString")> 0 prior to the if.

1 Like

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