How To write data from datatable into excel one cell

Help
1

Hi gyus…
How to write data from data table into one cell that is from excel without overwritting.
For example, In datable ,there are 1,2,3 .I want to write them into excel with this form[“123”] into one cell.

Screenshot%20(18)
Screenshot%20(18)1366×768 85.3 KB

2

Hi @Lwin_Moe_Aung

Welcome to the community.

I have few questions here.
Are you trying to combine values of a particular column into one cell? Or are you trying to combine values of a given row, and get the values of all columns and combine together into one cell?

3

Hi @Lahiru.Fernando
That is what I want.

combine values of a particular column into one cell

4

Use read column activity it gives IEnumerable output
Run That output through for Each And inside for each use an Assign activity
strVar=string.Join(“”,str+item.ToString)

and Then Use write Cell activity and indicate at which cell You want that to display.

1 Like
5

@Lwin_Moe_Aung

Sorry for the late reply. I guess you already got the answer from @Manish_Talele :slight_smile:

6

thank you for your reply @Manish_Talele @Lahiru.Fernando
I will try that

2 Likes
7

@Manish_Talele

Is string is variable?

8

it is a built-in Class which u can use

9

Thank you very much bro

1 Like