Hi Uipath Team,
1.I need to get current cell value horizontally row wise in a for each using Message box
2. I need to find total days and total cell values row wise
Basically Read the Sheet1 and find keywords and fill second sheet with total number of Y, N and Blank Cell Values
Any Help is Appreciated
Sheet AttachedBook1.xlsx (8.7 KB)
You can use For Each row
In that use For each item in row.itemarray
If or use switch
You will get after this For Each All Present Absent And blank in that row
Use them to write inn second sheet
Hi Bro, Thanks it Worked.
Also what if I have to count total no. of Days : Day1, Day2, Day2 . I tried but I guess string is case sensitive.