DIviding values based on column names


I have an excel in below format

And i am dividing column C with column B using write cell
as (C2/B2), but i need to divide using using column names because sometimes A and B column may interchange ,i should divide as (value/QR) ,
can someone tell me how to do .

1 Like

Hello @Karthik_Kulkarni,
you can do this!

  • Use Read Range and get output as outDataTable
  • Now Use For Each Row and Pass outDataTable, Inside For Each Loop you can use Assign activity like this
    intVar = Cint(row(“value”).ToString)/Cint(row(“QR”).ToString)


1 Like

double to integer error am getting

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