Create material library from excel using dynamo

Revit
1

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

image
image.png916×776 19.3 KB

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
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.

3

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

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?

6

Why can you not use this node?

Here is a screen:
image

1 Like
7

I don’t know how to

8

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

9

I did it:

image
image.png1329×557 145 KB

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

image
image.png916×776 19.3 KB

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.