I am trying to export Revit doors with room names to excel. So using Room.InsetOfBoundaries node to get the Doors that hosted in room bounding walls. However, I found the doors are reported thrice. This is not an accurate result.
Hi Hamish, I managed to extract the information using “Door.Rooms”. Everything works well, but when I am trying to export those data into Excel it’s not happening.
Would really appreciate it if you could let me know what I missed? Attached details below.
@Daniel_Hurtubise I am trying to create a multicategory (Floor Finish, Ceiling Finish, Door types, Furniture placed inside) data export from Revit to excel. So I feel Dynamo can deal this
Hi, it’s because your lists aren’t on consistent levels.
Depends on exactly what you want your Excel result to look like, but if you run a Flatten @ L3 you’ll get a result like the snip below. You could do various other flattens, transposes, etc to get the formatting results you want.