Write list to excel row

Help Studio
, ,
1

Data table are easy to write to an excel range. But what is the best way to write a list of strings to an excel row? As an example, I have this list {“a”,“b”,“c”,“d”}. Those strings have to be written respectively in cells B2, C2, D2, E2. Is it possible in one move (without iterating)?

2

Hi,

Greetings,

Yes, You can do it.

First create a empty datatable. Then initialize a list_Sample = {1,2,3,4}

then, use add data row activity. In property section, provide ArrayRow as list_Sample.ToArray

and then write that table to excel.

Mark it as solution if it resolves your issue.

Thanks

3

So a two step process: list ==> data table ==> excel.
I thought it would be possible: list ==> excel

4

@TALLIEU_Johan You can find attached how can be the solution provided by @Kalpesh_Chaudhari in the studio.
Community help.zip (151.3 KB)

5

Thanks everyone for the advices!! I will use indeed a data table to write to excel.
KR
Johan

1 Like
6

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