Hi there, I’m very new to Dynamo and trying to write a script to export quantities from my furniture schedules from Revit, but I haven’t been able to export the data in the way I want it, I would appreciate any help!
This is a large scale project with 8 levels and over 200 different furniture types, and the way we would like the schedule to read it’s sorted by furniture type and with the quantities of each type per level.
The way I have approached this it’s by creating a list per each level, then sorting these lists by type mark and then getting a count.
Following that, I created an overall list with all the type marks sorted by alphabetic order (this is the order I want them to come out in excel) - then I use that list and I compare it to the lists I’ve got by level (with the List.AllIndicesOf node) in a way that it gives me the position of each type mark in the overall schedule.
Finally, this is when I get stuck: I have my quantities in the 2nd list and I know which row, in excel, each of them belong to, as per my 1st list.
Example: 78 should appear in Row 59
I thought it would be pretty straight forward to map these values, but with the built-in Data.ExportExcel node I can only seem to get a start row and not a series of specific rows… is this something that can be done with Packages?
Or perhaps I have approached my issue all wrong? I would appreciate any suggestions!
Thank you very much,
Ana
