Import Multiple Parameters To Elements from Excel

Hello all,

I’m trying to set multiple parameters (in colums 4,5,6 & 7) to space element using the space number (Column 3) from Excel.


This is the excel sheet I have.


and this is the script I’ve made.

Somewhere I’m going wrong and I’m getting error that Element.SetParameterByName operation failed. The parameter’s storage type is not a string."

Can somebody please tell me where am I going wrong?

Use “String from Object” node and convert that values

Thank you for the response but that did’t help…

Can you change in Revit parameter storage type to text? or you can filter the parameters which are numbers. It is just type error.

Oh… OK Let me try that… Thank you…

Two parameter types were temperature & two were texts. I changed everything to text now…Results have changed now but not the desired one…

Can you show the parameter settings of “Air Conditioning Strategy”?

sure…

I do not have Revit on hand but i think the Element.SetParameterByName only accepts one parameter as input per Node.

So instead of doing List.Create try using 4 different SetParameterByName nodes,

I think the problems are the ‘lacing’ setting. could you share the dyn file? let me check it