Write cell excel activity

it is writing only in first cell even though i have taken counter to move to next cells…what is the problem??..


Here click on “indicate in excel” and point on “A1” in excel
Try the following

Regards

Hey @bhavana_kolli ,
Put the assign and the Excel application scope inside the loop,

1 Like

Hi @bhavana_kolli

Give that counter assign activity before wirte cell in the excel application scope. It will increment the counter and write the value to that cell.

Regards

all those are not working it is still writing in first cell only

initialize count to zero , also put “write cell” inside do while loop

Regards

1 Like

Hello @bhavana_kolli ,
Try incrementing the counter variable before the write cell and then use the Write Cell Activity.
Regards;)

1 Like

Did you put the activities inside a loop?
If yes and if it didn’t work then please send the xaml file
So that we can see where the issue exists

Hi @bhavana_kolli

Can you show the whole process what you are trying?

Main.xaml (24.8 KB)
check this

@bhavana_kolli
Try something like this

Also you might be facing error because of the scope of counter variable, Please keep it to the main sequence and try

Because of the scope it is getting default value
So Keep the variable scope to main sequence and try
Screenshot 2023-08-16 155445

Hi @bhavana_kolli

Try this workflow. I have made few changes and uploaded.

Sequence.xaml (21.7 KB)

Hope it helps!!

place the asign activity inside the loop assuming initial value of count is already declared

Hi @bhavana_kolli

Here you have used counter but not iterating any loop activity. Use for each row in datatable activity to iterate the each row in datatable. Inside for each insert the write cell activity and assign activity which used to increment the count.

If you elaborate your process steps, then I will give you the workflow where you have to place the for each row in datatable activity and all.

Hope it helps!!

Hi @bhavana_kolli

Please find below xaml for your reference

Sequence1.xaml (24.2 KB)

O/P:
image

I hope it helps!!

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