Hi,
I need help on correct the file on exporting points in excel for a particular family. I have so far worked on gettings points for the family however, need to transform that into data to export in excel.
Kindly review the image and assist.
Hi,
I need help on correct the file on exporting points in excel for a particular family. I have so far worked on gettings points for the family however, need to transform that into data to export in excel.
Kindly review the image and assist.
Hi @Suresh_Chotrani
Use the Point.Deconstruct from WombatDynamo package or Points.DeconstructPoint from Lunchbox. From that point, you will need to format the data with how you want it inputted into the spreadsheet.
Thanks @staylor
I have installed Lunchbox, after installation should I search on the left side to find Points.DeconstructPoint.
No need for lunchbox or wombat here.
Point.X
, Point.Y
, and Point.Z
nodes will return the values you need.
From there it’s a matter of List.Create, List.Transpose, and export to excel.
Alternatively [pnt.X, pnt.Y, pnt.Z]
in a code block will generate the list you need.
We all start somewhere!
Speaking of Jedi… I have to get back to the day (night?) job, got a light sabre to model tonight for a coming Dynamo Office Hour!
You aren’t providing a sheet name, but a function. use a string node to type Sheet1
or edit the code block to be "Sheet1"
and you should be all set.
And there we have a solution.