I have two columns named qty and rate and i want the result of qty*rate in my third column as shown in the pic.
What is the process for that?
you require the sum?
Use the formula in write cell activity as A2 * B2, then use auto fill range to multiply the values all the range in excel
- Read rang Excel.
- For each row result step 1.
- Assign : row(“qty*reate”) = (Cint(row(“qty”)) * Cint(row(“rate”))).ToString
1.Use excel application scope to read excel file.
2.In excel file apply formula in C2 cell…
3.Then use auto fill range activity and pass fill range in properties panel.
Read the excel file.
Use for each row.
In for each row use assign=
Then write to the excel file
which write activity should i take
one which is under workbook, that is “write range”
ok now in write range what should be the cell and data table?
just keep the cell blank,and select the data table which u used in for each activity.Dont forget to include add headers
cool it worked. thank you so much
You are welcome.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.