Struggling with Dynamo Script: Importing Excel Data into Material Parameters

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.


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.

2 Likes

Thanks for your input. I’m already familiar with the Dynamo Primer and have been working through it — this post was made because I encountered a specific issue that wasn’t resolved through the usual resources or forum searches.

While I appreciate the reminder about basic syntax, pointing it out without assuming I haven’t done any groundwork would be more helpful. Everyone hits roadblocks, and a collaborative forum works best when feedback is given with that in mind.

That said, I’ll double-check the string formatting in the node and see if that resolves the null return. Thanks again.

Unfortunately we can only go off the information provided in a post. We have to assume the bare minimum unless otherwise explicitly stated in the post. If someone doesn’t say or show that they tried an alternate method we can’t assume that they have. Keep in mind, these posts are meant to be informative to all users. In this case, there could be a newer user who finds your post while trying to solve a similar issue. If you’ve included nothing about trying additional syntax and we haven’t stated that as an option, they may not know to try it themselves. The intent with these conversations is never to put anyone down, but we have to cover everything to make sure nothing was missed and that everyone can follow along.

1 Like