Search Excel, then do this?

Revit
1

Hi Guy’s
I’m just now learning Dynamo and love it!
But I have hit a brick wall and can’t figure this one out and can’t find a similar issue already solved here.
All of my Room have the Room_Code parameter already filled out in Revit.
I need to search excel (Column B) for matching Room_Code, then when the match is found, populate the parameters COBie.Space.Category (Column D) and COBie.Space.Description (Column E) in the Revit model.
Is this possible?

2

Hi Ron,

A similar question was asked in this topic, that should get you started: https://forum.dynamobim.com/t/assigning-values-to-parameters-sequentially-using-lists/6683

3

T, I don’t see where this is looking at the excel file

my-excel-problem.jpg1143×862 339 KB

4

I figured you already knew how to import data from Excel into Dynamo. You can do this to import the data from your excel sheet:

blob.jpg1218×694 285 KB

After that use the output from the List.GetItemAtIndex nodes as shown in the previous example (the green block represents data from excel in that example).

5

Any idea what node was used to create this?

6

That’s just a code block, double click anywhere in the canvas and retype the same code. Have you had a look at the Dynamoprimer? A lot of this information can be found there: http://dynamoprimer.com/en/

7

Yep, thanks!

8

Ron,

For the original question @roncroke3743

It is probably do-able in Excel, but much easier using a database
Refer to the below example.

The select RoomCategory from TBL_ROOMS where RoomNumber=" + RoomNumber
part looks up the category based on the room number

Andrew

20161028 Room Parameter update.png1612×578 51 KB

20161028 Room Parameter update.gif1900×996 386 KB