List to excel layout

Lists-Logic
#1

Hi community,
I have some parameters values to write into excel file.
I must organize them like the joined picture.

List of combined lists
List of combined lists1001×679 34.5 KB

For a specific reason, I want to have on excel lists with horizontal values (from pink group on dynamo), and for the seventh “column” I want have vertical parameter values from the same item (from blue group on dynamo).

Dynamo capture
Dynamo capture3890×3154 593 KB

Dynamo capture 2
Dynamo capture 21043×892 139 KB

once done, I want that dynamo pass to the next item

PS : the blank line on the picture is just to explain that I’m passing to the next item.

i have to manage up to 500 items, so I’m focus on dynamo solution

thank you for effort

B-2 Fondation_Essai ghassen.dyn (67.2 KB)
Test dynamo.rvt (3.5 MB)

#2

Hi @Ghasen_Ouederni,
Good to see you after so long on the forum.
These solution should be able to help you take care of up to 1,000,000 items!

With Blank Lines
With Blank Line (60.9 KB)

Capture
Capture4964×1098 284 KB

image
image630×787 18.2 KB

Without Blank Lines
Without Blank Line.dyn (56.7 KB)

Capture1
Capture14674×930 265 KB

image
image633×792 19.8 KB

4 Likes
#3

Really nice work @AmolShah

2 Likes
#4

I can’t thank you enough for your involvement and your double solution.

I’ll test both of them, and give you a feedback. Even if i’m sure it will exactly what I expect.

Thank you

1 Like
#5

You’re most welcome @Ghasen_Ouederni.
Glad I could help you out.

#6

Thanks @Daan

#7

Hi @Ghasen_Ouederni, if you are having trouble visualizing the list data structure in dynamo to excel or data grid like format, you can always use the visualization node from AECTech.

1 Like
#8

Thank you
I’ll try it.