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

RobTech116 — Thu, 06 Oct 2022 13:43:42 GMT

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!

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

kirtimaantalwar — Thu, 06 Oct 2022 14:40:45 GMT

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

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

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

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