Checking data in columns

Help
, ,
1

Hi All,
I am trying to check the data in the following file Input-01-Aug-2019.xlsx (18.1 KB)

If you can see the punch records column, there I want to check the miss punches data. For example: In every cell there should be only in and out data (i.e., 09:14:17(in),12:34:42(out)). If there is any in,in or out,out it leads to miss punch (i.e., 09:14:17(in),12:34:42(in) or 09:14:17(out),12:34:42(out)).

So if there is any miss punch in the above sheet it will automatically recognize and send an email to the particular employee.

Please help me to solve this.
Thanks in advance!

2

Fine
—use excel application scope and pass the file path as input
—inside the scope use read range activity and get the output with a variable of type datatable named dt
—then use a for each row activity where pass this dt as input
—inside the loop use a IF condition like this
row(1).ToString.ToUpper.Contains(“OR”)
If the condition is true it will go to THEN part where we can use SEND OUTLOOK MAIL ACTIVITY with To mentioned as row(2).ToString

Cheers @suma123

3

Try like this use split functionality and check if condition

.Split(“in”.ToCharArray).Length-1 = 1 and .Split(“out”.ToCharArray).Length-1 = 1

then do your process

4

Thanks for your quick reply @Palaniyappan
I tried your sequence but it is not sending any email to the employee which has miss punches. Can you please send me the .xaml file

5

Thanks for your response @kalyanDev
I tried with that but getting an error.

image
image1366×768 60.2 KB

Please help me out

6

cellvalue.split you need to provide i mean you will get cell value right so that value.split like that you need to do.

When you are looping the excel data for each row you will get cell value right once you got the cell value then check this if condition with cell value.split