Excel Row Iterations

varsha_purswrt · March 17, 2018, 8:03am

Hi

I am trying to perform calculations on cells in excel rows and I need to do this in a loop -
E.g.
Col1 Col 2 Col3
3 2 5
5 6 8

I need the result to be (3-2)*5 and (5-6)*8. There are other columns in excel too.
Is there a way to automate this calculation using loops. I can do it for one row using expression. But unable to work with multiple list variables here.

Appreciate your response.

Thanks
Varsha

ashapkina · March 22, 2018, 4:04pm

Varsha, I think something like this should work in your case.

varsha_purswrt · March 20, 2018, 5:47pm

Thanks @ashapkina for your response.
Will try this approach.

mateenkk · March 24, 2018, 1:30pm

I tried it but unable to successfully done, getting step 4 error

ashapkina · March 24, 2018, 5:23pm

@mateenkk What error do you get? can you post your script here?

mateenkk · August 1, 2018, 11:51am

Workfusion How to write excel data on Webpage using workfusion script

mateenkk · August 10, 2018, 8:58am

Thanks @ashapkina and i have sucessfully implement that task you can watch this video

Again Thanks
Please like,subscribe and share it

ddivya · November 28, 2018, 9:04am

hey @ashapkina i have too got the same error on performing the above script provided by you
nd error is :-

please provide me the solution

ashapkina · November 28, 2018, 9:07am

@ddivya can you share the screenshot of the For Each and Expression actions, or share your script?

ddivya · November 28, 2018, 9:11am

here it is @ashapkina

ddivya · November 28, 2018, 9:14am

actually i have excel sheet in which columns
col13 col14 col15 col16 col17 col18
80% 45% 50% 60% 70% 80%
i have to find the average nd put into cell A15 = (col13++col14+col15+col16+col17+col18 )/6 .

ddivya · November 28, 2018, 9:39am

@ashapkina m waiting of your reply

ashapkina · November 28, 2018, 10:50am

@ddivya in each column (items), you only have 1 element, so ${item[3]}. ${item[4]}, etc. don’t exist.

In this case, the most efficient way is to open the Excel file and calculate the average using Excel function.

excel-average.zip (28.7 KB)

ddivya · November 29, 2018, 6:58am

thnx @ashapkina

ddivya · November 30, 2018, 6:04am

thnx @ashapkina above solution is working bt if i want to do it through below script then how to do it

ashapkina · November 30, 2018, 9:01am

As you only save 1 row from Excel, you need to save it to a List variable and then convert to a Number

calculate the sum

and divide by the total number of cells, then convert the result back to String and paste into Excel

excel-iteration.zip (7.2 KB)

ddivya · November 30, 2018, 9:18am

thnx @ashapkina bt it’ shows some error

ashapkina · November 30, 2018, 9:23am

It is caused by this bug

ddivya · November 30, 2018, 9:33am

thnx @ashapkina it’s solved