Read cells in Excel and add numbers together

[E.T.S]

Hello,

I have a number in two cells in Excel. I am using a read range activity to read those cells - what I would like to do is read the numbers in those cells and add them together but I am unsure how to do this as the output of read range is a data table.

So I would like the number in B7 and C7 to be added together and assigned to a variable

Thanks

[Anil_G (Anil Gorthi)]

@E.T.S

You can use read cells if you know the cell jumber and get them into string variable

Thencint(var1) + cint(var2)

If in datatable result = Cint(dt.Rows(0)(0).ToString) + Cint(dt.Rows(0)(1).ToString)

Cheers

[E.T.S]

Awesome thank you! At first the read cell didn’t work but I edited the properties to preserve the format and it worked thanks!