Datatable activities

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

@Kunali_Kharbikar

Follow the steps

  1. Read the data into Datatable dt
  2. Use for each row in datatable activity and give dt as input
  3. 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

  1. Use Write cell on cell "K2" and value "=SUM(D2:I2)"
  2. Use AutoFill Range Activity with Range as "K2:K11"

Both would work

Hope this helps

cheers

1 Like

Thank you so much.

1 Like