# Placing a block object (Tree) to a coordinate points from Excel (PENZ)

**URL:** <https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012>\
**Category:** Civil 3D\
**Tags:** dynamo\
**Created:** [April 7, 2020, 2:58pm UTC](https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012 "2020-04-07T14:58:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![robel-lemma.yemanebr](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@robel-lemma.yemanebr](https://forum.dynamobim.com/u/robel-lemma.yemanebr)\
**Post date:** [April 7, 2020, 2:58pm UTC](https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012/1 "2020-04-07T14:58:55Z")

</div>

Hi, i have a excel data that contain infromation about trees exsting along a road. The excel sheet consists of elevation (Z) , coordinates (X and Y) and the tree number §. I wanted to place assign block tree the given location ( as per teh excel) so far I have managed to do that but without the tree number. Tha means the trees are placed on the position but with out the name. Which command can i use to link the name from the excel . Thank you in advace.

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/b/5b34d88cc1276e6a7673afa1896ad2c0c4892052.png)

---

<div class="post-metadata">

**Author:** ![mzjensen](https://avatars.discourse-cdn.com/v4/letter/m/b77776/32.png) [@mzjensen](https://forum.dynamobim.com/u/mzjensen)\
**Post date:** [April 7, 2020, 3:10pm UTC](https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012/2 "2020-04-07T15:10:54Z")

</div>

How do you want the tree number to be assigned? Should it go in a block attribute, or just text in model space?

---

<div class="post-metadata">

**Author:** ![robel-lemma.yemanebr](https://avatars.discourse-cdn.com/v4/letter/r/eada6e/32.png) [@robel-lemma.yemanebr](https://forum.dynamobim.com/u/robel-lemma.yemanebr)\
**Post date:** [April 7, 2020, 3:12pm UTC](https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012/3 "2020-04-07T15:12:38Z")

</div>

in block attribute

---

<div class="post-metadata">

**Author:** ![mzjensen](https://avatars.discourse-cdn.com/v4/letter/m/b77776/32.png) [@mzjensen](https://forum.dynamobim.com/u/mzjensen)\
**Post date:** [April 7, 2020, 3:44pm UTC](https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012/4 "2020-04-07T15:44:40Z")

</div>

Use the BlockReference.SetAttributeByTag node and use the list of tree names as the input for the values.

---

<div class="post-metadata">

**Author:** ![sobeshan.pillay](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@sobeshan.pillay](https://forum.dynamobim.com/u/sobeshan.pillay)\
**Post date:** [November 16, 2021, 9:25am UTC](https://forum.dynamobim.com/t/placing-a-block-object-tree-to-a-coordinate-points-from-excel-penz/49012/5 "2021-11-16T09:25:17Z")

</div>

Hi @robel-lemma.yemanebr,

Is it possible to share the script you used here?