How To write datatable into excel one cell?

Help
, , , ,
1

Hi. I have a datatable and I want to write excel into one cell how can I write ?

2

hey
using the write range activity
or append range to add the data

1 Like
3

but I want to write in one cell ?

4

then use that activities
image

1 Like
5

Use the output data table activity which will output the datatable to a string variable. Then use the write cell activity to write that string into the specific cell in excel

1 Like
6

Try Write Cell passing the text like this:
String.Join(Environment.NewLine, myDataTable.Rows.OfType(Of DataRow)().[Select](Function(x) String.Join(" ; ", x.ItemArray)))

1 Like
7

which parts do I need to change because I dont understand :frowning:

8

only this myDataTable to your variable of DataTable.

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.