Comparing two excels and adding up the value of column

Help
, ,
1

i have two excel sheets have to compare two columns
1.read range
2.foreach
3.if
after comparing i need to sum up the value of the 3 rd column can anyone give idea on this?

2

you were almost done
once after this if we want to sum up all the value in 3rd column in a assign activity
–yourdatatablename.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“yourcolumnname”).ToString.Trim) ).ToString

Cheers @priyankavivek

4

i have 2 columns with different column names in excel so in condition what should i give?

5

Do you want to sum both the columns or only one column
Cheers @priyankavivek

6

image please c the screenshot sir the output i need is quantity to be added if condition satisfy

7

Fine no worrites
are they aligned like this same sheet or
each table is from different sheet
Cheers @priyankavivek

1 Like
8

each from different excel file
1.invoice excel
2.grn file

9

then that would work buddy

were we facing any issue out with this
Cheers @priyankavivek

1 Like
10

its shows enumerable is not a memeber of system.data.datatable

image
image1366Ă—768 90 KB

11

no worries
Kindly have a view on this

Cheers @priyankavivek

12

sure i look into this.thankyou

1 Like
13

did that work buddy
Cheers @priyankavivek

14

i was looking into…sir

1 Like
15

Fantastic
@priyankavivek