Create material library from excel using dynamo

#1

Hello to everyone.
I need to create a material library for revit starting from an excel file like this:


I think that dynamo can do it…so you have some ideas?
Each materials need to have almost 4 parameters:

  • code;
  • description;
  • unit;
  • cost.
    Thanks to all
0 Likes

#2

It can quite easily.

First duplicate an existing material, then set parameter values. Clockwork will help with the first step.

Give it a shot - you’ll see it can be quite easy.

0 Likes

#3

how clockwork can help me? can you share an example?

0 Likes

#4

Material.Duplicate node. Give it a shot and let us know where you get stuck. :slight_smile:

2 Likes

#5

I cannot use this node…can you share a screen?

0 Likes

#6

Why can you not use this node?

Here is a screen:
image

1 Like

#7

I don’t know how to

0 Likes

#8

Try and give this a read :slight_smile: How to get help on the Dynamo forums

0 Likes

#9

I did it:

Now I’d like to create a lot of materials starting from an excel file like this:

0 Likes

#10

Find the name column from excel and use that as a list of names in the material.duplicate node. Then use element.setparameterbyname for the other values.

0 Likes