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.
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?
That is what I want.
combine values of a particular column into one cell
Use read column activity it gives IEnumerable output
Run That output through for Each And inside for each use an Assign activity
and Then Use write Cell activity and indicate at which cell You want that to display.
Is string is variable?
it is a built-in Class which u can use
Thank you very much bro