Page 1 of 2 12 LastLast
Results 1 to 10 of 11
Like Tree10Likes

Thread: From Excel to Revit Drafting view

  1. #1
    New Member
    Join Date
    January 27, 2016
    Posts
    4
    Current Local Time
    03:54 AM

    From Excel to Revit Drafting view

    Hello guys. I hope you can help. I am still learning Basics in Dynamo and Tasks in my Company are getting tougher and tougher.

    I have some data in Excel from People outside of my Company. That list gets updated from time to time. It contains some text Information that i want to Show on my Sheet. Intention is that I do not need to owertype this info every time.

    My idea was to link this Excel file to drafting view in Revit where it would be written just by ordinary text command under Annotation tab. Is it possible? If not, do you guys have any other idea or a way to make this automatic??

    Thanks a lot!!!

    UPDATE: Maybe writing it on a Legend is better idea??
    Last edited by disperadun; December 15th, 2016 at 09:02 AM.

  2. #2
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,149
    Current Local Time
    04:54 AM
    I would suggest you either make the text a shared Sheet parameter which is shown in your title blocks. Or as a parameter in a detail item, which shows whatever text is filled in (Which you place either in a drafting view or on the sheet itself).
    Then it is really easy to get either all the sheets or all the detail items in the project. Filter for the ones that correspond to the excel text (By sheet number?). Read the text from excel then write into the parameter.

    Hope that helps you get started
    amoursol and PolynineStudio like this.

  3. #3
    Moderator
    Join Date
    February 2, 2011
    Location
    Montreal/Paris
    Posts
    761
    Current Local Time
    09:54 PM
    Seems doable
    From Excel to Revit Drafting view-2016-12-15_16-34-23.png

  4. #4
    Moderator
    Join Date
    February 2, 2011
    Location
    Montreal/Paris
    Posts
    761
    Current Local Time
    09:54 PM
    Seems doable
    Click image for larger version. 

Name:	2016-12-15_16-34-23.png 
Views:	81 
Size:	97.4 KB 
ID:	28772
    josephpeel and Dhilip like this.

  5. #5
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,149
    Current Local Time
    04:54 AM
    Yes. But surely using a family with parameters that you can schedule is more manageable than just text boxes?
    amoursol likes this.

  6. #6
    New Member
    Join Date
    October 9, 2013
    Posts
    1
    Current Local Time
    09:54 PM
    RF Tools has a feature: Draft XL which dynamically/live links between an excel document and a drafting view. It even converts the lines!

    Quote Originally Posted by disperadun View Post
    Hello guys. I hope you can help. I am still learning Basics in Dynamo and Tasks in my Company are getting tougher and tougher.

    I have some data in Excel from People outside of my Company. That list gets updated from time to time. It contains some text Information that i want to Show on my Sheet. Intention is that I do not need to owertype this info every time.

    My idea was to link this Excel file to drafting view in Revit where it would be written just by ordinary text command under Annotation tab. Is it possible? If not, do you guys have any other idea or a way to make this automatic??

    Thanks a lot!!!

    UPDATE: Maybe writing it on a Legend is better idea??

  7. #7
    Member
    Join Date
    September 8, 2014
    Location
    India
    Posts
    49
    Current Local Time
    09:24 AM
    HI,

    I tried the dynamo but im getting the text as single text one above the another, is it able to insert it as a table.

  8. #8
    Member J.Merlan's Avatar
    Join Date
    August 19, 2016
    Posts
    53
    Current Local Time
    07:54 PM
    I think the Dynamo graph gets you pretty close, but each element needs its own set of X,Y coordinates which is why they are overlapping. It would get more complicated, though because you would need to calculate the length and height of each cell to offset the text in order for it to appear like it does on the spreadsheet.

    Some time ago, I was developing an add-in that converts the range on a spreadsheet to an image and links the image in. I stopped developing it some time ago, though so I can't remember if it actually works as intended. I suppose if there was some interest I can try to find some time to get a release out.

  9. #9
    Member
    Join Date
    March 21, 2013
    Location
    Phoenix, AZ
    Posts
    171
    Current Local Time
    07:54 PM
    If you do not need to see the annotation family / element itself, you can use a note block schedule to report the values from a GA family. Use Dynamo, Excel, a custom GA family, and maybe a drafting view to hold all the instances. Make the GA a fixed, known dimension, and you can have dynamo place them in the view as well. The size and format of your schedule / "table" isn't dependent on the family instances this way.

    Deadlines had shifted my attention away from the graph below, but I *think* it's working (once you pick your GA family, target view, and xlsx).
    Attached Thumbnails Attached Thumbnails From Excel to Revit Drafting view-notes.png  
    josephpeel and PolynineStudio like this.

  10. #10
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,149
    Current Local Time
    04:54 AM
    Nice.
    I think theres a lot of potential with using GAs to store/show data with Dynamo.
    Not only to show it in a note block schedule, but also graphically in the GA itself.
    I was thinking about making a set of parametric GA's to show info as Bar/Pie/Scatter charts and this method would be great for adding the data.
    amoursol and PolynineStudio like this.

Page 1 of 2 12 LastLast

Similar Threads

  1. callout in drafting view
    By saberelkassas in forum Architecture and General Revit Questions
    Replies: 8
    Last Post: June 6th, 2016, 07:41 AM
  2. Copy from AutoCAD, Paste to Revit Drafting View
    By pittnat in forum Architecture and General Revit Questions
    Replies: 28
    Last Post: October 26th, 2015, 11:16 PM
  3. Reference other view: <New Drafting View>
    By amarkrish108 in forum Architecture and General Revit Questions
    Replies: 4
    Last Post: March 18th, 2014, 09:14 AM
  4. One drafting view on several sheets?
    By Jonatan Eriksson in forum Architecture and General Revit Questions
    Replies: 8
    Last Post: January 14th, 2014, 04:45 PM

Posting Permissions

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