topic Writing Single Data Item into Excel Cells - one below the other in Product Forum

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

sandeshtope — Tue, 25 Jun 2024 12:14:18 GMT

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?

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

devneetmohanty07 — Tue, 25 Jun 2024 12:47:14 GMT

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!

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

faheemsd — Tue, 25 Jun 2024 13:11:35 GMT

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.