Announcement

Collapse
No announcement yet.

Selecting Excel Cells into Dynamo to Revit

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Selecting Excel Cells into Dynamo to Revit

    Hi All, learning a little dynamo at the moment, playing with excel. Read a number of posts on here to get some great ideas, but I am having trouble, sort of. I have successfully, achieved what I wanted, which was to extract data from an excel drawing transmittal to create a sheet list in Revit.
    GetItematIndex.png
    My question though is, how can I make this more efficient? Is there a way to select specific cells out of excel rather than everything being dumped and then filtering what I want?

    Thanks in advance for any assistance.
    7

    #2
    I don't currently have it installed (IT issues at work) but try looking into the Bumble package by Konrad Sobon. It extends the Excel interoperability by a large margin.

    Personally I'm of the opinion that if you have a large robust document in Excel it's better to import all the data and filter it to suit but there are many ways of doing things

    Sol Amour

    Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
    Portfolio Website @ Cargo Collective

    Comment


      #3
      Great, thanks, I will take a look into that package!!
      In regards to filtering, I guess I don't mind either way, but my preference if I could, would be to nominate cells from the start, I think it is cleaner that way?
      7

      Comment


        #4
        Hopefully Bumblebee helps out in that regard then!

        Sol Amour

        Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
        Portfolio Website @ Cargo Collective

        Comment


          #5
          Just wanted to complete this thread by posting the solution I found in the Dynamo Bumblebee package suggested by amoursol.
          The image below has come from the primer available for this package https://konradsobon.gitbooks.io/bumb...ent/index.html
          Created by Konrad K Sobon. Was exactly what I was looking for, so thank you!
          readExcel3.png
          7

          Comment

          Related Topics

          Collapse

          Working...
          X