# Read Excel and set parameters, Make it easy :) **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [June 5, 2018, 8:02am UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511 "2018-06-05T08:02:47Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 5, 2018, 8:02am UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/1 "2018-06-05T08:02:47Z")
Good morning, I’m using an excel file to populate a parameter in Revit. It is working fine but I suppose that I can make it shorter because I need to apply this to all my pipes.[ReadExcel\_AdParameter.dyn](https://forum.dynamobim.com/uploads/short-url/4B2kVVf8VxreZAgsX2hsKSIoQbv.dyn) (136.8 KB) ![Capture2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/e/4efeb959ef32b3d17ae31f54f6de9f2d1772ea0e.PNG) (It is about the last part in blue)[P009283 Structure CDC - 180509.xlsx](https://forum.dynamobim.com/uploads/short-url/oWDItZ0kNhwt66bvTNLZipFHroX.xlsx) (60.8 KB) ![Capture4](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/f/bfeda701986697459ae213d7cbde205e73422aa4.PNG) ![Capture3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/c/1cdeabdb1f58ee8eb5d403af63ed9d3e3db2075b.PNG) ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 5, 2018, 8:06am UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/2 "2018-06-05T08:06:30Z")
Zoom in on your graph and use the camera option in the right corner. This way it is possible to actually zoom in on your picture which will make it easier to help you. 🙂 (I know you’ve uploaded your .dyn, but sometimes the obvious solutions are easier to give without having to start dynamo or close the project you’re currently working on. ---
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 5, 2018, 8:33am UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/3 "2018-06-05T08:33:19Z")
I think you will be glad with my printscreens 🙂 ---
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 5, 2018, 11:31am UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/4 "2018-06-05T11:31:59Z")
Ouch … is it not so easy to make it simple ☹ ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 5, 2018, 12:04pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/5 "2018-06-05T12:04:52Z")
Have not yet had a chance to try, but it seems that you should just load it all in and start sorting afterwards, an alternative would be to make custom nodes as you’re repeating a lot of nodes. Will get back when I have a spare moment… ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 5, 2018, 12:11pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/6 "2018-06-05T12:11:44Z")
I would need your .rvt file. Also you need to specify if the nodes are not from core package, this is why they are marked “unresolved”. Have you tried this instead of your jumble? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/1/01ea1a3ccea8fda55c1322af369e9c2f7962ec09.png) ---
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 5, 2018, 12:27pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/7 "2018-06-05T12:27:12Z")
thank you sir 🙂 [https://drive.google.com/open?id=17IE\_IAJevgH-\_azdadUBxv9ReEln3Pm5](https://drive.google.com/open?id=17IE_IAJevgH-_azdadUBxv9ReEln3Pm5) ---
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 5, 2018, 12:34pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/8 "2018-06-05T12:34:55Z")
With this proposition of you … how can I know that the right data (from excel) are in the right (ø) parameter? yeah those not standard nodes … When I use them then I write from which Package they comes, this one is from ‘ExcelReader’ ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/f/dff8de5150a47f6604427d812c826391d20d5661.png) ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 5, 2018, 12:48pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/9 "2018-06-05T12:48:14Z")
I don’t understand your question? You control the “data” by your “range” option on the excel reader… You have already sorted your elements thus: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/d/9ddbc5113b9ad2bf28802cda3090ddc128b49c38.png) But I don’t know how you’ve decided to sort your data, that is up to you… But it seems like you are assigning sizes very much manually and the sizes do not match your excel sheet, thus will they mostly be random if your topography change or you add a pipe… ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/a/baf6b83d08847beaf2107a9338c1f7e4f27d635f.png) ---
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 5, 2018, 1:01pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/10 "2018-06-05T13:01:36Z")
Ho my goodness!!! your proposal is really really easy! I just made it to complicate. But because I already sort my ø in Dynamo and it match my excell, I just have to link it has you said ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/3/63a52112d5b31d3375eaf1204d1c18e48ccd1c63.jpg) I test it and it works perfectly! in my Revit file I have indeed now pipes from ø16 until ø160 but not in my excell … but this is a test and will change that! Super man! I presentation for tomorrow will be better now 🙂 🙏🙏🙏🙏 ---
**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\ **Post date:** [June 5, 2018, 1:06pm UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/11 "2018-06-05T13:06:11Z")
I’m glad that it worked, couldn’t understand why it shouldn’t work 😛 I’m glad I could help, sometimes all you need is a fresh pair of eyes. ---
**Author:** ![xavier.renda](https://avatars.discourse-cdn.com/v4/letter/x/67e7ee/32.png) [@xavier.renda](https://forum.dynamobim.com/u/xavier.renda)\ **Post date:** [June 6, 2018, 7:40am UTC](https://forum.dynamobim.com/t/read-excel-and-set-parameters-make-it-easy/22511/12 "2018-06-06T07:40:30Z")
your eyes made my day 😂