# Place Family from Excel (XYZ) and set text value

**URL:** <https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488>\
**Category:** Revit\
**Tags:** excel, dynamo\
**Created:** [January 9, 2019, 12:17pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488 "2019-01-09T12:17:25Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![bvs1982](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@bvs1982](https://forum.dynamobim.com/u/bvs1982)\
**Post date:** [January 9, 2019, 12:17pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/1 "2019-01-09T12:17:26Z")

</div>

Hi,

I made this node which places a Families on specific XY(Z) coordinates (measured IRL).  
These coordinates are taken from an Excel.  
So every Family got an XY(Z) coordinate, but also a number (text value).  
Placing the Families works great, but i also need to fill in a unique number for each Family (from same Excel).  
I have no idea how to approach this last step. Hopefully someone cna help me with this.

[COORD\_EXCEL.xlsx](https://forum.dynamobim.com/uploads/short-url/tTIoCda25eIYuA7WRww6KWj43KZ.xlsx) (8.5 KB)  
[COORD\_TEST\_V3.dyn](https://forum.dynamobim.com/uploads/short-url/pdpdG3CotEDvvniJOMTcrAjZq15.dyn) (47.2 KB)

 ![COORD_TEST_V3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/c/6c3442b52cac971dc3e1dd35ff249b069380a083.jpeg)

**PS** I am still fairly new to Dynamo but i already made a few working graphs (by trail and error)  
as i am learning on the job.

---

<div class="post-metadata">

**Author:** ![m.rijsmus](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@m.rijsmus](https://forum.dynamobim.com/u/m.rijsmus)\
**Post date:** [January 9, 2019, 12:24pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/2 "2019-01-09T12:24:59Z")

</div>

![InkedCOORD_TEST_V3_LI2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/e/3e6692877c72546f0be02aa1b4dd438e61f3ab55.jpeg)

You were trying to set values to the Types not the instances

---

<div class="post-metadata">

**Author:** ![bvs1982](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@bvs1982](https://forum.dynamobim.com/u/bvs1982)\
**Post date:** [January 9, 2019, 12:40pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/3 "2019-01-09T12:40:10Z")

</div>

When i do it like this it does not work.  
 ![Error](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/1/616c37a873b6235f3e37eaa88b27ba84c562028a.jpeg)

---

<div class="post-metadata">

**Author:** ![m.rijsmus](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@m.rijsmus](https://forum.dynamobim.com/u/m.rijsmus)\
**Post date:** [January 9, 2019, 12:43pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/4 "2019-01-09T12:43:33Z")

</div>

can you show the excel file?

---

<div class="post-metadata">

**Author:** ![bvs1982](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@bvs1982](https://forum.dynamobim.com/u/bvs1982)\
**Post date:** [January 9, 2019, 12:44pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/5 "2019-01-09T12:44:02Z")

</div>

It is in my opening post 😀

---

<div class="post-metadata">

**Author:** ![m.rijsmus](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@m.rijsmus](https://forum.dynamobim.com/u/m.rijsmus)\
**Post date:** [January 9, 2019, 12:46pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/6 "2019-01-09T12:46:55Z")

</div>

looks ok to me,  
you can place a count node to check the amount of values you put in.  
or show the previews

---

<div class="post-metadata">

**Author:** ![bvs1982](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@bvs1982](https://forum.dynamobim.com/u/bvs1982)\
**Post date:** [January 9, 2019, 12:59pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/7 "2019-01-09T12:59:30Z")

</div>

🤦‍♂️

I picked the wrong node…

It had to be _Element.SetParameterByName_ instead of _Element.SetParameterValue **s** ByName **s** _

Thanks for your help @m.rijsmus

---

<div class="post-metadata">

**Author:** ![jason.thompsonUS6MG](https://avatars.discourse-cdn.com/v4/letter/j/9fc348/32.png) [@jason.thompsonUS6MG](https://forum.dynamobim.com/u/jason.thompsonUS6MG)\
**Post date:** [February 26, 2025, 6:27pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/8 "2025-02-26T18:27:03Z")

</div>

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/a/8a3da94539dbd24ea0509ff538d39d007e81e1ed.png)

what package is this node from??

---

<div class="post-metadata">

**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\
**Post date:** [February 26, 2025, 6:31pm UTC](https://forum.dynamobim.com/t/place-family-from-excel-xyz-and-set-text-value/30488/9 "2025-02-26T18:31:20Z")

</div>

Try not to revive 6 year old posts unless it’s absolutely necessary. In almost every case it’s probably better to just start a new thread. In this case, I think that’s the custom node the OP alluded to in the original post.
