Dynamo to Excel

Revit
1

Extracting data from Dynamo, which node should I use to implement the format I want (separating data)?

Point (X = -124.395, Y = 89.147, Z = 1249.003)

I only need XYZ point!
1

3
3.jpg317×720 135 KB

2

Try this:

Points
Points.png1386×924 68.9 KB

3

Also Lunchbox (package) Points.DeconstructPoint

Lunchbox_DeconstructPoint

4

Thank you for your reply, but also want to ask you, how to write X, Y, Z to Excel? What node should I use to link

1
1.jpg1379×724 199 KB

2

5

you can use this concept:

pointX
pointX.png655×560 27.1 KB

6

How do I combine with the original excel? And put XYZ at the specified location

1
1.jpg1411×673 184 KB

7

like this :

helpXYZ
helpXYZ.png1266×662 53.3 KB

8

You can do it the way @khuzaimah.ElecEng listed, or I typically try to keep the headings all together as a block so it’s easier to find.
It’ll look something like this:
Excel headers
Let me know if that works for you.
I quickly put together the nodes for the actual points, I just wanted to show the Headers code block. :wink:

1 Like
10

Thank you@quagliatol、@khuzaimah.ElecEng, Has been successful

11

welcome @helen60932111PLHPF, please mark it as Solved