# Sequence pile ID **URL:** \ **Category:** Uncategorized\ **Tags:** revit, dynamo\ **Created:** [October 15, 2025, 4:02am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702 "2025-10-15T04:02:44Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 15, 2025, 4:02am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/1 "2025-10-15T04:02:44Z")
Hi everyone, I am creating dynamo code to extract the pile ID , elevation at Top and elevation at Bottom parameter from Revit, I have a issue with outcome of excel file which piles are not in right order ( P01, P02….), After getting three parameters, I used list.create and then List.transpose to separate them but I can’t control the order of pile ! ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/9/b93a68a08f40d79c5159083008e95d9f7ecb1b5a.png) Does anyone have a idea how can I extract them in a right order? this is what i can see in the excel: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/e/ee6e3fd403b3b47b25af14d15f9a54383a23e810.png) Thank you for support. ---
**Author:** ![BimAmbit](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bimambit/32/192629_2.png) [@BimAmbit](https://forum.dynamobim.com/u/BimAmbit)\ **Post date:** [October 15, 2025, 4:17am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/2 "2025-10-15T04:17:05Z")
looks like u want to List.SortByKey and Element.Name as key to order the piles first. ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 15, 2025, 4:23am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/3 "2025-10-15T04:23:46Z")
yes thanks, but for key what should i exactly add ? ---
**Author:** ![BimAmbit](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bimambit/32/192629_2.png) [@BimAmbit](https://forum.dynamobim.com/u/BimAmbit)\ **Post date:** [October 15, 2025, 4:36am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/4 "2025-10-15T04:36:51Z")
try this: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/7/178adf6c101a6406e7f052fe782167ef003ebd8b.jpeg) ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 15, 2025, 4:46am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/5 "2025-10-15T04:46:35Z")
that’s great! thanks for sharing the only issue is we have extra 0 in the name of the pile, for instance: P01 changed to P001 ! ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/e/ee02a465582e8dae6341a6c4e97eebd5f12f73f7.png) ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 15, 2025, 4:55am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/6 "2025-10-15T04:55:25Z")
now it’s fix and done, thanks for sharing ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 15, 2025, 5:00am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/7 "2025-10-15T05:00:20Z")
just another item if i want to add the name of project parameter on top of column title, do you know how can i approach to bring them in this excel? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/f/dff9bdc43da3a3ce16968d81d543ab419737f593.png) ---
**Author:** ![BimAmbit](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bimambit/32/192629_2.png) [@BimAmbit](https://forum.dynamobim.com/u/BimAmbit)\ **Post date:** [October 15, 2025, 5:59am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/8 "2025-10-15T05:59:42Z")
ez i just typed them. but if u want to do it programmatically, thats a different story. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d8eac08a0e19c300bf3879eec2bbf187231116ba.jpeg) ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 16, 2025, 2:47am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/9 "2025-10-16T02:47:05Z")
yes this is work for me, if i want to change the parameter in that given excel sheet and then re-import to revit, do i need to do anything for shared parameter or built-in parameter? or just use import to excel code? ---
**Author:** ![BimAmbit](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bimambit/32/192629_2.png) [@BimAmbit](https://forum.dynamobim.com/u/BimAmbit)\ **Post date:** [October 16, 2025, 6:05am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/10 "2025-10-16T06:05:55Z")
not much, i think they behave in the same way when it comes to value assignment. ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 16, 2025, 10:05pm UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/11 "2025-10-16T22:05:43Z")
thanks, I use these sets of nodes to export to excel but if i want to create some node to re-import to revit, do i need to use list. tranpose again? or just add Import to excel node? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/c/fcab17031c2477f1625997b47c1740643f74f2fa.jpeg) ---
**Author:** ![BimAmbit](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bimambit/32/192629_2.png) [@BimAmbit](https://forum.dynamobim.com/u/BimAmbit)\ **Post date:** [October 17, 2025, 3:10am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/12 "2025-10-17T03:10:22Z")
first off, i would recommend starting a new graph. whether you need to transpose inputs again depends on whether you want to work with rows or columns. say you transpose them once again, then you get columns i think. then you could sort elements by “Asset\_General\_Identity\_Reference\_Instance” to make sure the order of elements matches with the excel file. then SetParameter a few times and call it a day. ---
**Author:** ![Mehrdad.Ghanizadeh2R](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@Mehrdad.Ghanizadeh2R](https://forum.dynamobim.com/u/Mehrdad.Ghanizadeh2R)\ **Post date:** [October 17, 2025, 3:16am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/13 "2025-10-17T03:16:18Z")
would you please show it on your dynamo if you don’t mind? do you mean i need to start a new graph and not continue this ? ---
**Author:** ![Brendan\_Cassidy](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/brendan_cassidy/32/7685_2.png) [@Brendan\_Cassidy](https://forum.dynamobim.com/u/Brendan_Cassidy)\ **Post date:** [October 17, 2025, 10:46am UTC](https://forum.dynamobim.com/t/sequence-pile-id/112702/14 "2025-10-17T10:46:18Z")
@BimAmbit is indicating you would have two files(DynamoScripts) and would have to run them when needed at the time. Import Script.dyn Export Script.dyn