# Create multilayer wall types from excel sheet (with new material)

**URL:** <https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170>\
**Category:** Revit\
**Tags:** excel, dynamo\
**Created:** [February 15, 2023, 9:29am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170 "2023-02-15T09:29:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bioand81](https://avatars.discourse-cdn.com/v4/letter/b/df788c/32.png) [@bioand81](https://forum.dynamobim.com/u/bioand81)\
**Post date:** [February 15, 2023, 9:29am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170/1 "2023-02-15T09:29:18Z")

</div>

Buongiorno,  
sto provando a creare muri multilayer con il nodo _Create Compound FamilyType_ partendo da un file excel.  
Ho realizzato lo script allegato ma sono riuscito a creare più muri monostrato, un muro multilayer ma non riesco a creare più muri composti da più strati.  
Successivamente vorrei provare a creare in automatico i materiali che non sono già presenti nel modello ma per ora sarei già felice di riuscire a creare i muri.  
Sono agli inizi con Dynamo quindi mi scuso per gli eventuali errori banali.

Google Transalte:  
Good morning,  
I’m trying to create multilayer walls with the _Create Compound FamilyType_ node starting from an excel file.  
I made the attached script but I managed to create multiple single layer walls, one multilayer wall but I can’t create multiple walls composed of multiple layers.  
Later I would like to try to automatically create the materials that are not already present in the model but for now I would already be happy to be able to create the walls.  
I’m new to Dynamo so apologies for any trivial errors.

 ![2022-02_BeB_Prova wall from excel da GeniusLoci_02_2023-02-15_10-19-16](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/f/df01b6fe219efe0a7cbe0a24bdf3e0cc5e775655.png)

[2022-02\_BeB\_Prova wall from excel da GeniusLoci\_02.dyn](https://forum.dynamobim.com/uploads/short-url/9S51xQ5NDS4xbwYG24M609FZJ8R.dyn) (42.4 KB)  
[Muri.xlsx](https://forum.dynamobim.com/uploads/short-url/2b9103LTCtf1ZLiXYXX18vx79Cz.xlsx) (11.1 KB)

Related post:

> [@Create wall types from excel sheet](https://forum.dynamobim.com/t/create-wall-types-from-excel-sheet/36812):
>
> Hi, I created a graph that collect wall thicknesses from excel i need to create thus types of basic wall family what is the simple way to do it? and how to remove duplicate thicknesses from list?

---

<div class="post-metadata">

**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\
**Post date:** [February 15, 2023, 10:07am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170/2 "2023-02-15T10:07:18Z")

</div>

Hi @bioand81,

To create several walls, set the longest lacing on the _Create Compound FamilyType_ node.

 ![2022-02_BeB_Prova wall from excel da GeniusLoci](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/6/3619e577458c49ca6f8eaf116bf1b617682d28ae.png)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/a/fa6352d0877c2877844f020e8b711e20810b73a8.png)

---

<div class="post-metadata">

**Author:** ![bioand81](https://avatars.discourse-cdn.com/v4/letter/b/df788c/32.png) [@bioand81](https://forum.dynamobim.com/u/bioand81)\
**Post date:** [February 15, 2023, 11:05am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170/3 "2023-02-15T11:05:33Z")

</div>

Thank you so much for your response! It works.

---

<div class="post-metadata">

**Author:** ![bioand81](https://avatars.discourse-cdn.com/v4/letter/b/df788c/32.png) [@bioand81](https://forum.dynamobim.com/u/bioand81)\
**Post date:** [February 19, 2023, 9:52am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170/4 "2023-02-19T09:52:51Z")

</div>

Hi @Alban_de_Chasteigner ,  
if the wall already exists is it possible to modify its layers by overwriting it?

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [February 19, 2023, 10:12am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170/5 "2023-02-19T10:12:22Z")

</div>

I believe the compound structure can be reset using this method:

> **[SetCompoundStructure Method](https://www.revitapidocs.com/2023/45f77d1a-c538-6fd2-7649-e461e66efbdd.htm)**
>
> Online Documentation for Autodesk's Revit API: 2015, 2016, 2017, 2017.1, 2018

---

<div class="post-metadata">

**Author:** ![hoangdv2304FBFY](https://avatars.discourse-cdn.com/v4/letter/h/ebca7d/32.png) [@hoangdv2304FBFY](https://forum.dynamobim.com/u/hoangdv2304FBFY)\
**Post date:** [July 31, 2026, 8:48am UTC](https://forum.dynamobim.com/t/create-multilayer-wall-types-from-excel-sheet-with-new-material/86170/6 "2026-07-31T08:48:54Z")

</div>

![04.WallsFromExcel](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/6/363a394a7e23c84942cf4777939932c5abfdc8b0.png)

I edited it, but I’m getting an error where it creates new walls with the same thickness of 200 (it seems like it copied the thickness of the sample wall). Please help me!
