Writing Single Data Item into Excel Cells - one below the other

[sandeshtope]

I need to write data from a data item into an Excel sheet, with each value written into separate cells, one below the other.

My data item contains six values, and I need to ensure each value is placed in its own cell in a column.

Values in DATA Item are like this -

10000
10001
10002
20001
20003
40003

Could anyone provide guidance or a step-by-step method to achieve this in Blue Prism?

[devneetmohanty07 · Accepted solution]

Hi @sandeshtope,

From what I could understand, you have all of these values in a single data item separated by a new line character.

If that’s the case, use the Split Lines action from the Utility - Strings VBO. This would ensure your data item gets converted to a collection with one column comprising of all these values in separate rows.

Once you have this collection, use Create Instance, Open Workbook and Write Collection actions to write the collection value to the desired range of the worksheet in the target excel workbook path.

Please let me know if it helps!

[faheemsd]

Dear @sandeshtope 

If your data item having the values line by line, you can us the clip board activity to paste the all the data into the excel

100

200

300

Copy the data to clip board and go the excel, active the Excel cell that you want to write the data and paste the values with Excel VBO.

1

3

4

5

8