Read from Excel and Write to Revit

Lists-Logic
, ,
1

Hello all, I have some issues continuing the script, probably some of you knows how to solve the issue.

First of all I have a very simple Excel sheet, please check the image below:
image

All I need to do is to match those values with the associated categories and write them into the family inside Revit.

I have found this solution to both read the Excel file data and read the all the elements I need.

image
image.png1534×860 103 KB

How should I match the Excel data to the element of categories? I tried list, map, filter, etc but no solution at this point.

Thanks in advance!

2

Look into list @ level functionality http://dynamobim.org/introducing-listlevel-working-with-lists-made-easier/

1 Like
3

hello,
use block List.DropItems with amount 1, to remove first row from imported excel data, to remove " category " word i mean,

then sort both list ( from excel one and from revit one) by category , it should be work with you

1 Like
4

Thank you @Kulkul for the info! I will try my best to solve the issue

5

Thanks @khuzaimah.ElecEng the drop Item is awesome! :smiley:

Now I am trying to sort the lists, i’ll let you know

6

Sometimes I can’t see the forest for the trees!! xD

The solution was right there and I didn’t see it, anyway I solved the issue all I needed to do is to connect all the data to the SET PARAM BY NAME

Thanks guys for helping me out, have a great day!