Value to write in a same cell

[syed1994 (syed)]

i have a scenario in which i have to write all the for each item value in a same cell like

[Palaniyappan (Forum Leader)]

Buddy @syed1994

this could help you for sure

Write multiple lines within a cell

Hello - Is using the Environment.NewLine in theory how I could read from a data table? I have an excel cell that contains two lines of text. Example: “New description without (acct) and Commas are not allowed” I’m using the ‘Add Data row’ activity and want the original data into a new DT. While looping, I can not add the column header “New description without (acct) and Commas are not allowed” to the new DT. When I debug, I see the column I need, however, I can not access it. I’ve tried: …

Cheers

[syed1994 (syed)]

i am using a for each row so its not working can u pls create a sample flow for that

[AshwinS2 (Ashwin S)]

Hi @syed1994
Use Excel application scope
Use write value activity with environment.newline
In the same cell

Thanks
Ashwin.S

[syed1994 (syed)]

It’s not working

[AshwinS2 (Ashwin S)]

Hi syed

I have done the xaml check it
test write cell value.xaml (6.4 KB)
test1.xls (25 KB)

Thanks
Ashwin S

[syed1994 (syed)]

Bro I want to insert the value of for each item in the same cell…

[AshwinS2 (Ashwin S)]

Hi @syed1994

print the names within for each item and gives it like that it will come

Thanks
Ashwin S

[syed1994 (syed)]

Not working bro

[Vineet2 (Vineet)]

I’ve edited Ashwin flow, It uses for each activity as well.

test1.xls (25 KB) test write cell value.xaml (11.0 KB)