Hi Guys,
I am trying to find the 10 percent of amount based on condition where “uber” is mentioned in Description field and place the value after calculating in the required field.
Amountcal.xlsx (8.8 KB)
Fine
Hope these steps would help you resolve this
—now use a excel application scope and pass the file path as input
—inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt
—now use a for each row loop and pass the above variable as input
—inside the loop use a assign activity like this
row(4) = Convert.ToInt32(row(3).ToString)/100*10
The use a write range activity and pass the above variable dt as input
Cheers @Rakesh_Tiwari
1 Like
How convert percentage to a number after I build data table 
Convert.ToInt32(row(3).ToString)/100*10
Can you please explain how to apply this in add data row
Store the percentage value in a varaible and in add datatrow add in array format
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123