How to auto select the column instead of typing Column Number for a formula?

Hi @xxGoRpa ,

One of the methods would be to Iterate over the Datatable that is the Excel file and Update the Column Value Accordingly.

You can follow the below Steps :

  1. Read the Excel file using Workbook Read Range Activity. Assign an Output Variable named DT.

  2. Next you can use an For Each Row In Datatable Activity, provide the Input Datatable as DT.
    Inside the For Each Row use an Assign Activity with the following :
    row("Total") = CDbl(row("Quality").ToString)*CDbl(row("Price").ToString)

  3. Outside For Each Row, Use Workbook Write Range Activity and use the DT value as the Output Datatable with Add Headers Property Checked.

If that is not the Expected Solution that you required, Request to share more information on how dynamically you want to access the values.

2 Likes