Hi,
I am stuck in one question in which i want to add marks of every subject in excel and then total marks kept in total marks column.
How to add marks?
can you provide some screenshot to clarify the question?
Test_Data_1.xlsx (11.1 KB)
i want to add all subject marks
Follow the steps
- Read the data into Datatable dt
- Use for each row in datatable activity and give dt as input
- Use assign inside it
Currentrow("Total Marks") = Cint(CurrentRow("English").ToString.Trim)+Cint(CurrentRow("Urdu").ToString.Trim)+Cint(CurrentRow("Physics").ToString.Trim)+Cint(CurrentRow("Math").ToString.Trim)+Cint(CurrentRow("Chemistry").ToString.Trim)+Cint(CurrentRow("Biology").ToString.Trim)
Or
- Use Write cell on cell
"K2"
and value"=SUM(D2:I2)"
- Use AutoFill Range Activity with Range as
"K2:K11"
Both would work
Hope this helps
cheers
1 Like
Thank you so much.
1 Like