Dynamo to Excel: Create an Excel file for spot coordinate

Revit
, , ,
1

Hi,
Im trying to make an excel file of spot coordinates of model elements(mainly assets).
I had reached to file one phase of generating XYZ coordinates in Watch node.
Next part of creating an excel, im putting a value in string node but it is not generating. I had typed in variables like x, X, projectPosition.EastWest, EastWest, .EastWest, Name, East, x= projectPosition.EastWest.
Below are the screenshots.

Doubt1
Doubt1.jpg1364Ă—714 210 KB

[Wetransfer link for dynamo file reference]
https://we.tl/t-Hi6B9RJb0S
I dont know how to proceed further. Please put your valuable suggestion. It would be thoughtful for me

1 Like
2

@Nissal Dynamo Points don’t have a parameter

3

Ok. so how should i proceed?
To make that watch box as an excel file.

-Thank you for your response salvatoredragotta :blush:

4

@Nissal I’m not sure what you are trying to do. if you just need the x,y,z just use Point.X, Point.Y, Point.Z nodes

5

I will clear again. XYZ are spot coordinates of elements. As in revit it shows North East of an element.Z is the height.
Trying to make that in excel format.

I had tried your inputs Point.X , Point.x, point.X, point.x, Point_X, Point=X (with all caps small also)

6

@Nissal are you using nodes?

image
image.png1304Ă—359 14.1 KB

1 Like
7

I didnt tried that. I havent seen how to use that.

I was referring to youtube link for dynamo.

At 9.10, he used the same string node and generated his output.

doubt4

image bit blur. he typed Name in string node and got his room names in output

8

Try it and see if you get what you want

9

Point.X isn’t a variable you can call using the GetParameterValueByName node, it is its own node/method.

GetParameterValueByName is mostly used to get parameters from Revit elements, not Dynamo geometry.

You can get parameters of Dynamo geometry using built-in nodes, as seen here: http://dictionary.dynamobim.com/#/Geometry/Point/Query/X

pointx

10

Hi tried to used to point X node.
Still not getting how to connect these values in excel formatdoubt%205

11

@Nissal Exporting to excel is very trivial. Search this forum or google it.

http://dictionary.dynamobim.com/#/Office/Excel/Action/WriteToFile

12

Hey,

Maybe don’t over think it?

image
image.png833Ă—417 55.1 KB

image

If you want the Mark you can do this…

image
image.png965Ă—447 63.8 KB

image

And if you want headers, you can do this…

image
image.png1202Ă—450 95.4 KB

image

If you want the location as separate columns, here’s an alternative approach if you’re interested…

Capture
Capture.png3184Ă—1110 227 KB

image

Hopefully that’s enough to get you going…

Don’t be afraid to just play with the settings.

Cheers,

Mark

1 Like
13

Spot Coordinate v 1.0.dyn (24.3 KB)

1 Like
14

Mark.Ackerley salvatoredragotta kennyb6 ashwinash112 Big thank you to all of you. Resolved my query. :slight_smile:
-Cheers :partying_face: