# Sheets by Excel data

**URL:** <https://forum.dynamobim.com/t/sheets-by-excel-data/64473>\
**Category:** Revit\
**Tags:** revit, excel, dynamo\
**Created:** [May 28, 2021, 1:19pm UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473 "2021-05-28T13:19:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![renanemeyer](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/renanemeyer/32/114498_2.png) [@renanemeyer](https://forum.dynamobim.com/u/renanemeyer)\
**Post date:** [May 28, 2021, 1:19pm UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473/1 "2021-05-28T13:19:02Z")

</div>

Hello everyone!

Practically everything I learned from Dynamo, was due to this forum, so I came to ask for help  
I am looking to change some parameters of my Revit sheet using excel  
I based my routine on some similar ones on the forum, but I’m stuck in a part that I can’t change.

The entry reads the spreadsheet and a text (which will be associated in column G of excel)  
So when you type “ALI-TERR”, you must fill in the rest of the data on the sheet with what is on the line

 ![exx](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/d/ad1ef0cfa263241d792e2cba5280bc6dad9a957d.png)

My sheet takes data from a revit table.

 ![tab](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/3/c3f30dd2119333a23c5261834ddef4a8f7acf0ee.png)

the data in column A of excel, go to B of the Revit table  
Excel “B” go to revit “C”

How do I get it to take the data only from this entry line and not from the entire spreadsheet, to complete my sheet?

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

[Sheets.dyn](https://forum.dynamobim.com/uploads/short-url/jWF77FovACOVXYKTrlhrGcV1s4X.dyn) (35.6 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:** [May 28, 2021, 1:54pm UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473/2 "2021-05-28T13:54:55Z")

</div>

Hey,

I’m not sure I understand exactly… Are you looking to extract only data from column G and check whether the cell contains “ALI-TERR”?

How about ‘String Contains’ instead of ‘==’

Hope that helps,

Mark

---

<div class="post-metadata">

**Author:** ![AmolShah](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/amolshah/32/103244_2.png) [@AmolShah](https://forum.dynamobim.com/u/AmolShah)\
**Post date:** [May 28, 2021, 3:16pm UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473/3 "2021-05-28T15:16:34Z")

</div>

@renanemeyer Try this: [Sheets.dyn](https://forum.dynamobim.com/uploads/short-url/gUcta0jyFQ4oVkAQE375q5NvXvr.dyn) (36.6 KB)

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/0/407f29d8aa032e9fd1fb68edbfd38f9b1afbfeb3.png)

---

<div class="post-metadata">

**Author:** ![renanemeyer](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/renanemeyer/32/114498_2.png) [@renanemeyer](https://forum.dynamobim.com/u/renanemeyer)\
**Post date:** [May 28, 2021, 4:17pm UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473/4 "2021-05-28T16:17:30Z")

</div>

😀 great! worked perfectly! thank you so much

do you know how to inform me how can i fill in the data for a certain column in the spreadsheet? like this?  
I’m using element.setparamterbyname but the paramter name = the column name is not working

 ![aaa](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/2/620ab042fcd75f25512cae67d27b2653e689f784.png)

---

<div class="post-metadata">

**Author:** ![renanemeyer](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/renanemeyer/32/114498_2.png) [@renanemeyer](https://forum.dynamobim.com/u/renanemeyer)\
**Post date:** [May 28, 2021, 4:32pm UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473/5 "2021-05-28T16:32:35Z")

</div>

![BBBB](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/4/74907065d6c45c6048a4bf00693ebf7bb4306a96.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:** [May 31, 2021, 7:36am UTC](https://forum.dynamobim.com/t/sheets-by-excel-data/64473/6 "2021-05-31T07:36:58Z")

</div>

Hi,

Shouldn’t you be setting the parameter of the Element? Not the Schedule?

If so, I would export the Element ID to your Excel as a column, and use that to Get the Element and Set the Parameter…

Hope that helps,

Mark