Struggling with Dynamo Script: Importing Excel Data into Material Parameters

[Salma]

Hi everyone,

I’m currently working on a Dynamo script where my goal is to import values from an Excel database into Revit material parameters. It sounds straightforward: map the Excel data to the materials and update the parameters accordingly.

However, I keep hitting a roadblock. Every time I run the script, I get the error:

“Material parameter name not found.”

What’s confusing is that the parameter definitely exists in the materials — I can see it manually in Revit! ( It is a project parameter)

I’ve tried using different nodes like Element.SetParameterByName and making sure my data types match, but no luck so far.

[Nick_Boyts]

I highly suggest you work your way through the whole Dynamo Primer to get a grasp on the basics. It’s also always good to search the forum for similar topics to see what other people have tried before posting something new.

If you look at your parameter name, the node is actually returning a null. That’s because you haven’t actually defined anything. The name needs to be a string and you’ve just created a variable with no value. You can either use a String node or you need to wrap your text in quotes to make it a string in a code block.