Use assign for write data but not write?

I use assign for write data in current row.
But output don’t write anything.
image

I want write output in column Output after end for each row.

Please guide me for solve it.
Thank you

Hi @fairymemay

Have you use write range workbook activity with add headers Property after each row in datable

Check in the debug whether it is Passing in to if condtion or not

@fairymemay

Instead of “Equal” Use “Contains”

try to debug and find wheather the value is saved in curentRow(“output”)

@rlgandu You mean in condition?

@fairymemay

Yes in condition only please check.

@tazunnisa.badavide value = N

image

But I want write data after loop for each row.

Yes I change already.

just use write range workbook aftr the loop

the rows in the data table will be updated once the condition met.
use write range workbook with data table name

1 Like

@fairymemay

Use write Range workbook activity to update the output Cells after the for each row in datatable

@fairymemay
Use Write range activity

It show error as below.

@fairymemay

Excel is running in the background

Close the excel file. if not visible.Go to task manager and remove the excel

please close the excel file which is open before running the process

@fairymemay

At the first use kill Process activity
image

1 Like

I open excel in excel process scope.
After this step not show excel as below.

image

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.