Curtain wall elements' vertices coordinates to Excel

Geometry
, , ,
1

Hello! I come to your aid as a basic Revit user, and new to Dynamo.
I have this curtain wall, with panels and crossbars. I need to obtain, for each panel and each crossbar, the eight coordinates of the vertices that define them (so, I assume every vertice would have each XYZ coordinates), and export them to Excel. Any ideas?

thumbnail_image
thumbnail_image1195×719 20.1 KB

I followed this script from this topic (How can I get X,Y,Z in individual column in excel by using Dynamo) and I ended with what I suppose is the coordinates of one of the faces of one of my curtain wall panels, which is nice but I don’t know how to continue and get all the coordinates of all the elements’ vertices. Any help? Thanks in advance!

dynamo_coordenadas_prueba_2024-03-05_01-12-09
dynamo_coordenadas_prueba_2024-03-05_01-12-092484×1180 182 KB

captura_excel_prueba_coordenadas
captura_excel_prueba_coordenadas1663×905 135 KB

2

Hello Amanda,

It is great to see you in the community! I hope you will find an answer for your question quickly!

For this type of operation, my suggestion would be filter all the panels first using Categories and all elements of categories nodes. Then, using Element.Faces you can obtain each surface of the panel. From that point you can create an algorithm to filter the required surfaces and work on how to obtain corner points. Here is an example:

Surface
Surface2576×846 197 KB

Please let me know if you need furher help! Good luck!