without using collection

[NayanaH_P]

 Take an Excel file with columns - Name, Age, 10 marks, 12 marks. Fill another column with the sum of 10th and 12th marks. Don't use collection in this task.

------------------------------
Nayana H P
------------------------------

[ewilson]

Hello @NayanaH_P,

If you're using the Excel VBO, you could use the Set Cell Value action to input a formula into the cells of the ending column that would perform the calculation (ex. =SUM(A3:A4) ). This assumes you know the range of the final column (i.e. the number of records to fill in).

Alternatively, you could probably process the file as a CSV one line at a time. This assumes you can get the file in CSV format though. If you can, then you read each line, perform the calculation on the 10th and 12th mark, and then right that value to the end of that line as a new column (i.e. comma and the new value).

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------