cancel
Showing results for 
Search instead for 
Did you mean: 

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

sandeshtope
Level 5

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?

1 BEST ANSWER

Helpful Answers

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!

---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

View answer in original post

2 REPLIES 2

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!

---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

faheemsd
MVP

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