Multiple CSV files to Excel at once

Lists-Logic
,
1

Hello everybody,

I’m a beginner in Dynamo and I try to import multiple CSV files (23 files precisely) in one Excel file at once thank to the node FileSystem.GetDirectoryContents. I’ve successed to load these files but the form of the result in Excel is not satisfying.
In fact, datas in CSV files are differents but titles are the same in each one of them. In my Excel I don’t know how to have the titles just once and all the data of the differents .csv files.
Any ideas ? If possible without Python script. :sweat_smile:

You can find screenshots of my dynamo and the result on Excel :sweat_smile:

image
image1244×580 266 KB

Thank you in advance

2

Are you trying to write them to one excel sheet or many sheets?

3

I’m trying to write them to one Excel sheet

4

Try using a List.Flatten with the level set to @Level 2 before you push to excel.