Excel row checking

Help
1

Hi fnds,

pls help me
How to check value is greater than 100.00 and send mail
output req:
id 45 102.00
id 46 501.00

image

2

Hi
kindly have a look on to this thread
–but while using need to change few things
–in the read range mention the range as “A37” so that it would start from that row
–then replace with your columnname in the SELECT Method along assign activity

hope this would help you
kindly try this and let know for any queries or clarification
Cheers @venkateshtangudu

3

thanks…bro
im checking

1 Like
4

great
cheers @venkateshtangudu

1 Like
5

Book1.xlsx (9.5 KB) Main.xaml (6.1 KB)

Hi,

getting errors…cannot find the column name

6

here you go its working fine
filter.zip (18.1 KB)

Cheers @venkateshtangudu

1 Like
7

Hi
write line is not working to see the output…in the below format like
dt 45 10200

image
image1536×864 43.6 KB

8

May I know what was mentioned in writeline activity
Cheers @venkateshtangudu

9

Hi

dt1.Tostring

10

That’s why
Use output datatable activity and pass the dt1 as input and get the output with a variable of type string
Then pass that string variable to writeline activity
Cheers

11

Hi bro,

actually i should throw exception if value is more than 100

12

hi
how can i split this like this and throw exception as well mail in below format
id 45 value 102.00
id 46 value 501.00

image
image1536×864 44.5 KB

13

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