Mapping multiple property values to Objects

[pccheung]

Dear all,
I have 5 objects(manhole), each have 3 properties. I also have an excel file with arrayed data, shown below:
WIDTH DEPTH HEIGHT
manhole A 10 5 3
manhole B 6 7 8
manhole C 3 4 2
manhole D 7 8 9
manhole E 8 6 5

how can i mapped these value to the parameter with dynamo with the set property node?

Thanks in advance!

[hosneyalaa]

HI
LOOK AT

Adding values to property of object

[propSetFromEXCEL]

AND

Import Propertyset data from CSV/Excel

Update on the thread. I’m trying to make the script work in a way that all the solids on the layer get the right propertyset+value from the excel file. Though currently only the 1st object gets its property values filled in. (all the object get the propertyset added though) Does anyone know how to get this to work?Propertyset V3 (all on layer).dyn (151.0 KB) [Propertyset V3 (all on layer)_2019-12-23_09-57-45]