Need assistance in writing collection values to blank cells of excel sheet

[RobTech116]

Please help me with a solution for below query:

I have a collection[COLL] with fields A & B.
There are 5 rows of values in [COLL].
Now I need to update these values to an excel sheet "Test.xlsx".
There are already some records in "Test.xlsx" with coumn names Q,W,E,R,T,Y.
Now the requirement is to update:
[COLL.A] values to the next blank cell in W column of "Test.xlsx" And 
[COLL.B] values to the next blank cell in T column of "Test.xlsx" .

Thanks in advance!

[kirtimaantalwar · Accepted solution]

Hi @RobTech116,

There are multiple ways in which you can design the solution.

You can try below solution -

1. Use the Collection Manipulation - Delete Field Action. Pass Input Collection as [COLL] and Field Name as "B" and in output parameter, create new collection "A". 

2. ​ Repeat the same step for Column B. Now, you'll be having two collections with Column A Data and Column B Data.
3. Use MS Excel VBO Actions to write data - ​a) Go to cell "B1" b) Get next empty cell down  c)  Write Collection(Use the cell reference got from step b  and collection A Data in the input parameter).
4. Repeat step 3 for other column.

Many Thanks,
KirtiMaan Talwar