Create material library from excel using dynamo

**onofriolofu** · January 24, 2019, 3:27pm

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

**JacobSmall** · January 24, 2019, 3:33pm

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.

**onofriolofu** · January 24, 2019, 3:51pm

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

**JacobSmall** · January 25, 2019, 12:54am

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

**onofriolofu** · January 26, 2019, 3:33pm

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

**Jonathan.Olesen** · January 26, 2019, 3:34pm

Why can you not use this node?

Here is a screen:

**onofriolofu** · January 26, 2019, 3:53pm

I don’t know how to

**Jonathan.Olesen** · January 26, 2019, 3:54pm

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

**onofriolofu** · January 26, 2019, 4:11pm

I did it:

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

**JacobSmall** · January 26, 2019, 7:20pm

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.