Read row excel if found not equal0 show alert

Help
, , ,
1

I want to read the column C in all row excel.
If found value not equal0 show alert error.
If all rows in column equal0 show alert nothing.

alert one message

image

Please guide me about it.

2

Hi @fairymemay

Use read range and use for each row in dt
If row(“Type”). ToString.equals(0)
Then use message box as alert and in else don’t do anything

Thanks
Ashwin.S

3

Use Read Range workbook activity to get all value of excel and store it into a datatable type variable then use For each Row Activity and then use read column activity for column C and then put if condition inside for each row i.e. row(“Type”).to string and message box for alert message.

4

hi

1.User read reange activity and read the excel and store it in in_DT
2.use for each row to read each row for the excel file
3.In side the Do use assign activity and create a variable to assign the row value
Assign variable = row.item(“TYPE”).Tostring
4. use if activity to check the value is “0” or not
Condition for if - Assign variable = “0”
5. in else part of if use message box for the message to display

thanks…

6

Hi @fairymemay alerting

You can log message with level of information as warning for alert and level of information as info for non alert

Hope it helps

7

Assign one flag to false globally then use for each row activity and use if condition to check zero or not if yes then in then part pf IF activity use assign activity flag to true and use break activity or in else part empty.

thanks

8

@Sagar_Gupta1 Now, It’s work true.
But I think it duplicates in for each row.

check error.xaml (12.3 KB)

Please suggest to me about it.

9

@fairymemay - Read the entire column in a loop…Inside a loop set up a Counter for the # of rows, and Set up another counter if value equals 0.
Outside of the loop check this–> If the both the counter(total rows) = Counter(Zeros) then Alert nothing…If counter(total rows) > Counter(Zeros) = Then alert error.

10

@fairymemay …Here is the solution:

CheckError.xlsx (8.2 KB) Main.xaml (11.9 KB)

Mark this as solution, if it solves your query.

@fairymemay - Any update on this??Have you tried the provided solution?