Change automation pipe diameter by excel!

Hello :slight_smile: !!!

Can you help me?

By picture, I created a pipe system with sprinklers, but i can’t change pipe size automaticly.

I don’t know package for Sprinkler by flow, I had searched but it is not.


SP FLOW.xls (22.5 KB)

Hi lenhat, judging from the picture, did you perhaps connect your input to the node incorrectly?

From your code example, it seems to me like your input to “parameterName” and “value” should be switched.
See image below

Additionally, I am not entirely sure what your python script actually achieves? The one you uploaded seems to just give “0”, regardless of what you put in your Excel sheet.

Hope it helps!

Hi there,

I’ve modified your script and now it is working for pipes. The thing is that you have to go back to revit, select all pipes and reapply type in order to get the correct pipe fittings after apply this script with dynamo because you are just changing pipe diameters, not pipe fitting diameters.



i could not find manage.Remove Nulls
could you map where is the this node thanks

Hi there,

Try to use those ones:

I follow your script. it’s like it does not work, and there are some errors
please help me
Thank you!

It is an old script and it was made for Dynamo 1.3. If you are using Dynamo 2.0 you should make some changes in order to adapt it to dynamo 2.0


1 Like

Hi Manel,

I tried your script but still its not working. Could check my custom script. thanks



SP FLOW.xls (22.5 KB)pipe sizing using dynamo 2018 read from excel ManelFernadez.dyn (38.1 KB)Capture

pipe sizing using dynamo 2018 read from excel ManelFernadez_modified.dyn (35.6 KB)

Hi there,

The thing was dynamo doen’t get properly the values from the excel file. I’ve add a node to convert the values to an integer value and works for me.




yhe file is corrupt