Hi. I have a datatable and I want to write excel into one cell how can I write ?
using the write range activity
or append range to add the data
but I want to write in one cell ?
then use that activities
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
Try Write Cell passing the text like this:
String.Join(Environment.NewLine, myDataTable.Rows.OfType(Of DataRow)().[Select](Function(x) String.Join(" ; ", x.ItemArray)))
which parts do I need to change because I dont understand
only this myDataTable to your variable of DataTable.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.