without using collection

NayanaH_P — Mon, 15 Aug 2022 13:36:00 GMT

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
------------------------------

RE: without using collection

ewilson — Mon, 15 Aug 2022 14:01:00 GMT

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
------------------------------

topic RE: without using collection in Product Forum

without using collection

RE: without using collection