Write variable in excell and next in other cell .. so it won't overwrite

Hello,

I have data in excel sheet with a for each i use the data to search data on a website. With a get text activity i get some text from the website and put it in a variable. I want to write the data/variable to a excel cell. But now it overwrite the first value. How can i fill a cell with the variable and the next cell with another value?
Please who can help me?

Greetings,
Eddy

Hi @eddycarsouw

Can you provide any Screenshot for the same ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Hi @eddycarsouw,

try to use append range activities.

Regards,
Omkar P

Hello Er Pratik,

Hereby the screenshot of the flow

Best regards,
Eddy

Hello Reddy,

I tried append range but the get text activity before the append range has a variable as output. The append range needs a databable as input. In don’t now how than.

Best regards,
Eddy

Hi @eddycarsouw

So first of all declare “rowIndex” variable within ForEachRow Activity properties
After that within If statement use write cell activity and for that within properties you will see Range/Cell property der you declare “ColumnChar i.e A,B,…”+(rowIndex+2).ToString

Before doing this can you send the Excel file SS and depending on that tell me that where you want to append the next value so that i can share you more approprite solution.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like