Wall Export to Spreadsheet

<span style=“color: #343a41;”>Hi everyone, </span><br style=“color: #343a41;” /><br style=“color: #343a41;” /><span style=“color: #343a41;”>I have just started using Dynamo and I have made my first script. The idea of it is for the dynamo script to rip out the chosen wall information out of any revit model and populate a particular spreadsheet for analysis. It all works fine, except for the the x,y,z coordinates. The x,y,z coordinates don’t associate themselves with the wall that they come from. As in, the spreadsheet could say Wall 1, but then it may be listing the x from Wall 3 and the y from Wall 2… Does anyone know how I order the coordinates by wall ID? </span><br style=“color: #343a41;” /><br style=“color: #343a41;” /><span style=“color: #343a41;”>Shawnee</span>

<span style=“color: #343a41;”>Revit Wall Export</span>

This should do it … the order it comes out in is ID,START X, START Y, START Z, END X, END Y, END Z, VECTOR X, VECTOR Y, VECTOR Z, VECTOR LENGTH

 

Test

fOR SOME REASON THE IMAGE IS RUBISH… HERE IS THE FILE

 

Test.dyn