Write Collection to Excel via Work Queue

[ashlp2904]

Hi Friend,
I'm trying to write the collection data to excel but when it writes to Excel, it writes the entire row on the same cell.
It does not goes down to the next cell to write the row. (It keeps on updating and overwriting on the same row)
Please advise. the row is not getting updated on the next empty cell.

 

[janejeba]

How did you copied the data from excel to collection. Are you using Get worksheet as collection - VBO.

 

[Manikanta]

Hi Friend,
I'm trying to write the collection data to excel but when it writes to Excel, it writes the entire row on the same cell.
It does not goes down to the next cell to write the row. (It keeps on updating and overwriting on the same row)
Please advise. the row is not getting updated on the next empty cell.

Hey @ashlp2904
U need to create another column with a name and for that column u need to map ur output (I mean ur cell reference).
Then u may get ur requirement output in ur regarding cell reference row total.