Sorted sheets in Excel

Lists-Logic
1

Hi there.
First post and very new to Dynamo.

I’m looking for a way to export all sheets from Revit to Excel. I’ve succeeded with exporting the list but I want to sort by 2 categories under Identity Data. I have isolated the data in Dynamo but I’m stuck for now. This is probably too much spaghetti but the best I could do after viewing ALOT of post from this forum.
BTW. Is there a “public library” of .dyn - files somewhere?

Transmittal script (1)_2023-02-25_04-56-07
Transmittal script (1)_2023-02-25_04-56-072856×2496 620 KB

Regards Kasper

2

Samlet
Samlet1920×1091 229 KB

Here is the file if you wanna check it out:

Sheets.Excel.dyn (95.3 KB)

3

Sheets

So basically the same build as in Revit if possible.

Thanks

4

Maybe My post wasn’t clear enough.
I want My sheets (RED) to be sorted under info (GREEN) by Idendity Data (BLUE)

Screenshot_2023-02-26-13-17-23-69_40deb401b9ffe8e1df2f1cc5ba480b12
Screenshot_2023-02-26-13-17-23-69_40deb401b9ffe8e1df2f1cc5ba480b121079×2399 233 KB

Is it even possible?

Thanks

5

First, personally I’d hardcode the inputs. Sometimes drop-downs can change and it causes no end of bother.

You’d really benefit from some list management…

image
image1626×694 134 KB

If you want the parameters in the separated lists instead of the sheets then use the green wire connection instead.

Obviously I have not used ‘Mapper’ or ‘Kategori’, this is just an example of how to separate each.

Then you want to feed each list into a different column or sheet in your excel.

The excel node can be fed lists too.

Hth.