# Retrieving Dynamo Node Values from Excel

**URL:** <https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683>\
**Category:** Revit\
**Tags:** revit, excel, dynamo\
**Created:** [April 18, 2023, 10:12pm UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683 "2023-04-18T22:12:44Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Navid\_Hoorzad](https://avatars.discourse-cdn.com/v4/letter/n/ba8739/32.png) [@Navid\_Hoorzad](https://forum.dynamobim.com/u/Navid_Hoorzad)\
**Post date:** [April 18, 2023, 10:12pm UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/1 "2023-04-18T22:12:44Z")

</div>

Hello,

I’m looking for some help to expand on my existing dynamo script.

This is my Dynamo script. It looks at Duct Accessories for a parameter “Asset Type” and if the value matches “Fire System Damper”, it will populate two other parameter values (in this example "OmniClass info).

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/0/d07a0d5feba581a5befd43bba576a6fb641fcb41.png)

What i’m looking to do is to pull the “Fire System Damper” value from a Excel sheet and have it move to the next row in Excel once the top row is completed.

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

Here is an example of what I think the Excel file would look like. After I get the OmniClass info done, I want to do the same for Acronym and Asset Group columns  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/a/2a1fbe39a30a2b23a543fef04de5833e7d1a4feb.png)

Any help would be much appreciated.

Thanks!

---

<div class="post-metadata">

**Author:** ![Navid\_Hoorzad](https://avatars.discourse-cdn.com/v4/letter/n/ba8739/32.png) [@Navid\_Hoorzad](https://forum.dynamobim.com/u/Navid_Hoorzad)\
**Post date:** [April 18, 2023, 11:28pm UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/2 "2023-04-18T23:28:12Z")

</div>

I was able to get a bit further by adding the Data.ImportExcel node and building that out. Now I think my issue is the columns have multiple rows of data and I need the dynamo script to run through each one one-by-one but it’s trying to run through all of them at once. I think…  
[Asset Type Automation.dyn](https://forum.dynamobim.com/uploads/short-url/hUCfXPxc5F3hnwV6uEqFatTZlmn.dyn) (147.2 KB)

---

<div class="post-metadata">

**Author:** ![Mark.Ackerley](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mark.ackerley/32/79310_2.png) [@Mark.Ackerley](https://forum.dynamobim.com/u/Mark.Ackerley)\
**Post date:** [April 19, 2023, 9:40am UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/3 "2023-04-19T09:40:42Z")

</div>

Heya,

I would expect you’ll need to edit the data structure to get what you want… To tell Dynamo that you want this item to only have this data, you group up all the data for each item into a sublist, put the item into a sub-list and use list levels…

This kind of thing, apologies I don’t have time to give you a proper example, but hopefully you get the idea… I’m sure the Dynamo primer has good info on this…

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

Hope that helps,

Mark

---

<div class="post-metadata">

**Author:** ![Navid\_Hoorzad](https://avatars.discourse-cdn.com/v4/letter/n/ba8739/32.png) [@Navid\_Hoorzad](https://forum.dynamobim.com/u/Navid_Hoorzad)\
**Post date:** [April 19, 2023, 3:51pm UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/4 "2023-04-19T15:51:46Z")

</div>

Thanks Mark! This does help. I’ll give it a try 🙂

---

<div class="post-metadata">

**Author:** ![Navid\_Hoorzad](https://avatars.discourse-cdn.com/v4/letter/n/ba8739/32.png) [@Navid\_Hoorzad](https://forum.dynamobim.com/u/Navid_Hoorzad)\
**Post date:** [April 19, 2023, 5:12pm UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/5 "2023-04-19T17:12:56Z")

</div>

I got a bit further but i’m getting a odd output element IDs. It’s just cycling between two element IDs for some reason!! My BoolMask Out shows 500 results but those 500 items mostly share the same element ID…super odd

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

---

<div class="post-metadata">

**Author:** ![Mark.Ackerley](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mark.ackerley/32/79310_2.png) [@Mark.Ackerley](https://forum.dynamobim.com/u/Mark.Ackerley)\
**Post date:** [April 20, 2023, 10:17am UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/6 "2023-04-20T10:17:20Z")

</div>

Hey,

I think you want to simplify and play around a bit to better understand what’s going on… I suspect for simplicity you might want to split out the 2 streams of parameters… It’ll be a little less efficient but you’ll find easier to control… I think the problem is that your data structres aren’t aligned, so you’re getting outputs from your boolean mask that you’re not expecting.

Hope that helps,

Mark

---

<div class="post-metadata">

**Author:** ![Navid\_Hoorzad](https://avatars.discourse-cdn.com/v4/letter/n/ba8739/32.png) [@Navid\_Hoorzad](https://forum.dynamobim.com/u/Navid_Hoorzad)\
**Post date:** [April 21, 2023, 6:51pm UTC](https://forum.dynamobim.com/t/retrieving-dynamo-node-values-from-excel/88683/7 "2023-04-21T18:51:52Z")

</div>

Thanks, so I built it out and it does work without the BoolMask node but the script is much too big to replicate for all my excel rows. I need to find a solution to be able to run parallel inputs of Excel rows into Revit parameters. Any advice on what other thing I can try?  
[Asset Type Automation.dyn](https://forum.dynamobim.com/uploads/short-url/hg2SGwFXqAkA6GhA9fGXmN3Xkn.dyn) (160.0 KB)
