How to add value in excel row sequentially

Help Studio
, ,
1

PFA

image
image1815×637 23.1 KB

From the above attached excel sheet i need the values pasted like “Expected Status”
but my bot is pasting the value from web application into excel like this

PFA

image
image703×649 27.2 KB

image
image715×666 18.7 KB

image
image678×666 17 KB

i used index counter, followed by repeat number of times activity under this i was placed write cell

How to fix this error?

Thanks in advance

2

Hi @rsr.chandu

Dis you place the index+1 assign inside number of times loop?

If so move it to out to the for each ro
Cheers

3

Hi @rsr.chandu,

What about this workflow

convert Column value to List with filtered empty value then add to rows.

Input
image

Output
image

Workflow

image
image1102×699 38.7 KB

Thanks,
Rajkumar

4

Can you share this xaml workflow

5

Hi @rsr.chandu ,

Kindly check this

Xaml
15.xaml (11.3 KB)

list_ShipmentID

(From row In in_dt.AsEnumerable() Select Convert.ToString(row("ShipmentID").ToString)).ToArray.where(Function(x) Not String.IsNullOrWhiteSpace(x)).tolist

list_Status

(From row In in_dt.AsEnumerable() Select Convert.ToString(row("Status").ToString)).ToArray.where(Function(x) Not String.IsNullOrWhiteSpace(x)).tolist