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 !
Does anyone have a idea how can I extract them in a right order?
this is what i can see in the excel:
Thank you for support.
looks like u want to List.SortByKey and Element.Name as key to order the piles first.
yes thanks, but for key what should i exactly add ?
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 !
now it’s fix and done, thanks for sharing
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?
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?
not much, i think they behave in the same way when it comes to value assignment.
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?
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.
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 ?
@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
