# Creating Multiple Project Parameters from Excel in Dynamo **URL:** \ **Category:** Revit\ **Tags:** revit, excel, dynamo\ **Created:** [December 30, 2019, 10:45am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923 "2019-12-30T10:45:10Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![cobipal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/cobipal/32/87202_2.png) [@cobipal](https://forum.dynamobim.com/u/cobipal)\ **Post date:** [December 30, 2019, 10:45am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/1 "2019-12-30T10:45:10Z")
Hey guys, I’ve been trying to create multiple project parameters from Excel in Revit using Dynamo. The problem I think is that CreateProjectParameters Node can only create one parameter at at time. Is there anyway around this? Also, how do I convert “Categories” from Excel which is in String to actual Categories so the node understands it properly. Thanks Manish ![2019-12-30 16_09_44-Window](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/6/469b4283d0c04b3f21a52785004201e2b5b01b86.png) ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/d/9dae8293e26b9c06dd38cb155814925ea6e62cc4.png) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [December 30, 2019, 4:59pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/2 "2019-12-30T16:59:58Z")
What does the error say? I’m pretty sure you can create multiple project parameters at once, you just need to have your lists setup correctly. Category.ByName will get the Revit category for you. Also make sure you’re using the correct Parameter Type and Parameter Group names. Look at the Archi-lab nodes to get a better idea. ---
**Author:** ![patrick\_podeyn](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/patrick_podeyn/32/86368_2.png) [@patrick\_podeyn](https://forum.dynamobim.com/u/patrick_podeyn)\ **Post date:** [December 30, 2019, 9:33pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/3 "2019-12-30T21:33:27Z")
The CategoryList input is looking for a category and you’re inputting a string. What is the error you’re getting on the CreateProjectParameter node? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/a/4a592993faf09f887e32d45f55a63f740001ec84.png) You can also retrieve categories by a string input with this combo. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/7/07b755bc8ad1f7d85e8a97f09e4b08f3aeb5970c.png) ---
**Author:** ![Mepdot](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mepdot/32/106281_2.png) [@Mepdot](https://forum.dynamobim.com/u/Mepdot)\ **Post date:** [December 31, 2019, 6:07am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/4 "2019-12-31T06:07:42Z")
Hi patrick, Can you show an example for that node. Error getting on the CreateProjectParamenter node. Warning: Parameter.CreateProjectParameter operation failed. Invalid parameter type. [Parameter.CreateProjectParameter.dyn](https://forum.dynamobim.com/uploads/short-url/2lB2vhjAZofO4AXz2UFNIk6n5tE.dyn) (96.3 KB) ![Parameter.CreateProjectParameter](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/7/a72eef7ad5f0029e87d3b33f3617bd25fdf302b3.png) [Parameters from Excel.xlsx](https://forum.dynamobim.com/uploads/short-url/3mtdvcf51kIH20E5gM3q02ZG1Tc.xlsx) (10.1 KB) ---
**Author:** ![cobipal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/cobipal/32/87202_2.png) [@cobipal](https://forum.dynamobim.com/u/cobipal)\ **Post date:** [December 31, 2019, 6:18am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/6 "2019-12-31T06:18:00Z")
It says “invalid parameter type” But my types are all correct which you can see from the List.Map below ![2019-12-31 11_47_00-Dynamo](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/5/959975fb2768b51604d6026b3de6293e81e493a5.png) ---
**Author:** ![cobipal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/cobipal/32/87202_2.png) [@cobipal](https://forum.dynamobim.com/u/cobipal)\ **Post date:** [December 31, 2019, 6:39am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/8 "2019-12-31T06:39:13Z")
[Project Parameters\_Excel.xlsx](https://forum.dynamobim.com/uploads/short-url/kD80vO5bWLmaAfNUAHoR76r28P6.xlsx) (14.4 KB) [Create Project Parameters Script.dyn](https://forum.dynamobim.com/uploads/short-url/rpSzESQcxdGFKjfY1FbFZiGjyT0.dyn) (54.8 KB) ---
**Author:** ![patrick\_podeyn](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/patrick_podeyn/32/86368_2.png) [@patrick\_podeyn](https://forum.dynamobim.com/u/patrick_podeyn)\ **Post date:** [January 2, 2020, 9:59pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/9 "2020-01-02T21:59:33Z")
@Mepdot Here is an example of the workflow working. This node builds project parameters off of a shared parameter file. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/9/5939280f61f5a66c349f324ccd3a11f89a652e72.jpeg) I am unsure why the results display a “null” value, but here is what it produced in Revit and what my shared parameter file looks like. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/f/6f4b459a1a2477ad58627f97d98d063ea46ff25b.png) ---
**Author:** ![cobipal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/cobipal/32/87202_2.png) [@cobipal](https://forum.dynamobim.com/u/cobipal)\ **Post date:** [January 3, 2020, 3:04am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/10 "2020-01-03T03:04:55Z")
Thanks Patrick! I figured it out yesterday and made a small tutorial on this, although I would like to further enhance it. ---
**Author:** ![Mepdot](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mepdot/32/106281_2.png) [@Mepdot](https://forum.dynamobim.com/u/Mepdot)\ **Post date:** [January 3, 2020, 7:03am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/11 "2020-01-03T07:03:59Z")
@patrick_podeyn, @cobipal Thanks a lot… But one more Question? As you can see in the below image with a red mark on the list. ![Parameter.CreateProjectParameter Unsolved 1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/4/a4e43f69c63f359fe184c917b88cfa50152c7842.png) Which are not created because of the “Invalid parameter type” i.e “DIMENSIONS” in the red mark? ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/2/423b099475505a533e4e612b075b04ac3a421492.jpeg) # Can you answer if, I need Dimensions or Materials and Finishes as Parameter Group. [Parameter.CreateProjectParameter SOLVED.dyn](https://forum.dynamobim.com/uploads/short-url/LSmNCkV0GNTRukHUvQVMyV21MK.dyn) (25.8 KB) [Parameters from Excel UPDATED.xlsx](https://forum.dynamobim.com/uploads/short-url/7zkrTi0YNtQFeXOhluZjMWcqoHW.xlsx) (10.1 KB) ---
**Author:** ![patrick\_podeyn](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/patrick_podeyn/32/86368_2.png) [@patrick\_podeyn](https://forum.dynamobim.com/u/patrick_podeyn)\ **Post date:** [January 3, 2020, 2:56pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/12 "2020-01-03T14:56:29Z")
It needs to be “PG\_LENGTH” not “DIMENSIONS” I would suggest placing the Parameter Groups nodes from ArchiLab for a reference when building your Excel spreadsheet this way you know what the proper callout is for the parameter group input. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/c/ec6d0db33b66a20c4ec62cbddfc33ff13d6ba958.png) ---
**Author:** ![Mepdot](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mepdot/32/106281_2.png) [@Mepdot](https://forum.dynamobim.com/u/Mepdot)\ **Post date:** [January 4, 2020, 4:34am UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/13 "2020-01-04T04:34:47Z")
@patrick_podeyn, @Nick_Boyts, @cobipal Hey guys, I tried as Patrick mentioned with Archilab Node “Parameter Group” As shown below ![Parameter.CreateProjectParameter Unsolved 2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d884d04f5b043f1d6a84d74bd71e0d1b124c7339.png) However, the output is still pending. It as given output as below which is not expected. ![Capture Unsolved 2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/c/0cf3b9cee0aae7445ea2af2a21f6e86bd3363484.jpeg) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [January 6, 2020, 2:27pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/14 "2020-01-06T14:27:36Z")
As I mentioned before, you need to do the same thing with Parameter Type. You’re not using valid types. ---
**Author:** ![munderwood](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/munderwood/32/85796_2.png) [@munderwood](https://forum.dynamobim.com/u/munderwood)\ **Post date:** [January 23, 2020, 4:55pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/15 "2020-01-23T16:55:33Z")
As a _very_ new Dynamo user, I’m pretty jacked about this thread! I was able to follow along with @cobipal 's video above 👍 , and created a graph that actually added parameters from an excel file. I do have some questions though: 1. Shared parameters-How do I know if the parameters are being created from my shared parameters file, and if they aren’t, how do I get that to happen? (After I typed most of this post, I saw Mepdot’s image above with the red box around the Shared Parameters radio button, and I could prove out that same result, but… I tried editing the excel file to slightly change the parameter names ("-" to a “\_”), and I got the same result, even though no shared parameter of that exact name existed.) 2. I noticed that each time I ran the graph, every parameter in the list would be duplicated. Is there a way to exclude existing project parameters from the write? Even better, if I change family categories in the excel file, can the existing proj parameters be updated? Currently, if each of the parameters in the list is associated to a different family category (in the excel file), all of the categories will be applied to all of the project parameters that are created. 3. Each time I run the graph, my excel spreadsheet closes. Not a deal-breaker, but is there a setting that I’m missing? Thanks! ~Mike Currently running Revit 2019.2 and Dynamo 2.0.3.0. [Create-Project-Parameters-mju-pub.dyn](https://forum.dynamobim.com/uploads/short-url/yhsIVFeucUmgZ0V7JR5HiAJPwKh.dyn) (27.7 KB) [Project Parameters\_Excel-mju-pub.xlsx](https://forum.dynamobim.com/uploads/short-url/j3pDAkCrzWeztFAvDAGxw0MPNgh.xlsx) (14.8 KB) ---
**Author:** ![Folke](https://avatars.discourse-cdn.com/v4/letter/f/a9a28c/32.png) [@Folke](https://forum.dynamobim.com/u/Folke)\ **Post date:** [January 23, 2020, 10:44pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/16 "2020-01-23T22:44:05Z")
Hi munderwood. I have an answer to your secound question. i have made a script, that are looking into the current project parameters, and by using the node List.Setdifference, i’m excluding the parameters that already are in the project 🙂 ![Create parameter](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/7/9783d1de2f84abf3d3c45c68bc22b4e002b3fa57.png) ---
**Author:** ![munderwood](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/munderwood/32/85796_2.png) [@munderwood](https://forum.dynamobim.com/u/munderwood)\ **Post date:** [January 27, 2020, 2:09pm UTC](https://forum.dynamobim.com/t/creating-multiple-project-parameters-from-excel-in-dynamo/44923/17 "2020-01-27T14:09:39Z")
Thank you Folke! I tried plugging it in, but couldn’t get it to work. I will tinker with it a bit more when I get time and check back in.