Results 1 to 2 of 2

Thread: New to Dynamo

  1. #1
    Junior Member
    Join Date
    December 15, 2014
    Posts
    46
    Current Local Time
    09:41 AM

    Not allowed! Not allowed!

    New to Dynamo

    Hello all New to Dynamo, i am sure someone might have done this earlier but couldn't find the solution. Planning to export schedules into excel and then update required information in excel and then push the info back to revit.

    First step prepared schedule in revit which I have done but I wanted these sorted them properly before I can use Data.exportExcel node to export them into excel.

    What my requirement is the excel should have "Scheduled Level", "FCU_label" as 1st and 2nd columns and sorted aswell. The remaining information can follow in any order. My idea was to index these two from the rest(using code block) and use "list create" node to reconstruct the list as required. But didn't worked. Any ideas? Thanks in advance.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.JPG 
Views:	20 
Size:	37.2 KB 
ID:	38030  

  2. #2
    Member
    Join Date
    November 4, 2012
    Posts
    117
    Current Local Time
    10:41 AM

    1 Not allowed! Not allowed!
    Some notes:
    - Schedule.getdata is from bimorph nodes, not a built-in one, if someone wants to reproduce this. Fortunately this package was installed for me.
    - You can set up sorting in the schedule, and if you just want to modify the data in excel and not print it, you can just use the VLOOKUP function in excel, and this doesn't care about the order of items in the list.
    - Also I never exported a schedule this way, I always recreated the schedule as a dynamo data structure with selections. It makes management of data easier, so you don't have to modify the schedule AND the dynamo graph if you want to change something. Element.Parameters and Element.GetParameterValueByName will be your friends.
    - I encourage everyone to learn dynamo, but for this exact functionality a free plugin exists: Import-export excel: https://apps.autodesk.com/RVT/en/Det...26048826015851

    But a solution to your question:
    -To reorder the columns use List.Transpose->List.Reorder->List.Transpose.
    - For sorting I like to use the List.SortByFunction. There are other options.

    See the image as a solution, I had to hide some parts of the data:
    Click image for larger version. 

Name:	2019-12-11_14-34-06.png 
Views:	18 
Size:	123.8 KB 
ID:	38031

Similar Threads

  1. Replies: 0
    Last Post: August 12th, 2019, 03:24 PM
  2. Replies: 0
    Last Post: August 26th, 2018, 09:15 PM
  3. Replies: 0
    Last Post: October 20th, 2017, 02:15 PM
  4. Replies: 0
    Last Post: November 19th, 2014, 12:45 PM
  5. Replies: 0
    Last Post: August 26th, 2013, 08:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •