Read a list of data from Excel and assign the data to Revit Family parameters by parameter name

HI HI,

I’m a new Revit user and having trouble entering repetitive data on Cobie. So I’d like to set up DYNAMO. How can I do that? Read a list of data from an Excel sheet column(parameter name), the row is the data string, and assign the data to Revit Family parameters by parameter name :smiling_face_with_three_hearts:

These three parameters are commonly used for all families, so the input data remains the same. But there are too many families, and it takes a lot of time to enter them in the Schedule table. So I want to make a DYNAMO

paramter auto input.xlsx (8.8 KB)

I may be a bit blunt by saying this.

But new to Revit AND wanna use Dynamo. Not sure if that is the best order of doing things :sweat_smile:.

Also this :backhand_index_pointing_down: .

:smiling_face_with_tear: HI, let me read…

I would suggest you have a look at the following tool, and see if there is anything that could be setup as a config in the first instance.

Autodesk COBie Extension for Revit

Then look at dynamo afterwards

2 Likes

as above, new to revit and dynamo…i would definitely learn more about how revit works first to give you and understanding of what is needed when you get to the dynamo stage.

i’d start with creating simple schedules in revit and manually inputing data there, seeing how your revit elements are responding to that data - and then trialling this in the opposite direction - input data to your families and see what happens with the schedules.

what you’re asking to achieve is one of the simplest things to do with dynamo but the above workflows will give you a proper understanding of where to begin once you step up to dynamo.

i dont mean to insult your intelligence but the structure of your original question within this forum shows that you are just starting out.

Hi @Higashi.K

Welcome to the forum

  • You will find a large percentage of the posts on this forum relate to Excel/Revit integration.
    (you’d think Autodesk might get the message and build it in to the core application….)
  • It is best to go through other forum posts first- I’m sure you’ll find something which is exactly what you want
  • You’ll find people on this forum are extremely helpful- but it is best to post a specific question/problem showing exactly where you are stuck in Dynamo, rather than an open question asking someone to do it all for you

Andrew