headerL
headerR
Left effects
Right effects
Important Site Information:
Notice, if you are using Internet explorer to view this site, it is strongly recommended that you run it in compatibility mode or use firefox or google chrome
TopL TopM TopR
MiddleL


You are not logged in currently. If you are not already a member, please take a moment a complete our free registration (a valid email is required to verify your registration). Once you complete 2 minute registration process, you will be able to create new threads, reply to threads, rate and subscribe to threads, and much more.
If this page has helped you, be sure to give it a google "+1", by clicking the icon to the right or anywhere you see it on this page.
6/29/2009 2:27:02 PM
 
superJMuser
433 Posts
Joined 08/19/2009
www.revitinfo.com
Entry Type:
Issue
Category:
Import/Export/Linking
Subcategory:
Excel
NO Direct Excel Link into Revit  

There is no direct link from Excel into Revit Currently.  See workaround below.

1) Open the excel file you want to put into Revit by opening it in excel. Select the cells you want and 'ctrl+c' to copy them. Open AutoCAD, and in a drawing file, go to the "Edit" menu ---> "Paste Special" as "AutoCAD Entity. This will make the excel file data into AutoCAD data and now the AutoCAD file can be imported into Revit.

2) Create an image file out of the document and import that using the following procedure:

A) Go into your excel schedule. Highlight the print area, file>>print area>>set print area.
B) File>>Page Setup>>Adjust to 100% normal size
C) File>>Print>>Set printer to adobe pdf
D) While still in Adobe pdf document properties>>advanced>>paper size>>postscript custom>>edit custom page size>>42x30 (or whatever paper size it takes to fit the entire schedule on @ 100%)
E) OK>>OK>>OK>>Rename and Save to desired location
F) Right click pdf>>open with acrobat 7.0
G) Document>>Crop pages>>Check Remove White Margins
H) File>>Save As>>Save as type>>JPEG
I) In Revit, View>>Drafting View>>Enter a name & set scale to 3/8”=1’ (you may have to mess with the scale to get you text size to come out right, but this is what worked for me)
J) Right click new drafting view>>Set discipline to Coordination & sub discipline to whatever you want
K) Drag and drop schedule jpegs into drafting view.
L) Create a sheet and drag and drop drafting view into sheet
____________________
8/14/2009 9:04:47 AM
 
madeforworship
8 Posts
Joined 12/19/2008
Re: NO Direct Excel Link into Revit
In Response To:  superJMuser

I haven't tried this personally, but this looks like a pretty good Revit extension for using Excel with Revit.

 

http://www.dotsoft.com/revit/xl2cad.htm

_______________
m4w!


You must be a registered user to Rate entries.  Please take a moment a complete our free registration (a valid email is required to verify your registration).


You must be a registered user to Subscribe to individual entries.  If you would like, you can subscribe to all future new posts and/or replies by filling out this form.  Otherwise, take a moment a complete our free registration (a valid email is required to verify your registration).

Below is a list of things to be aware of when browsing through the Revitinfo.com Forum:

 1)  As a registered user at Revitinfo, you automatically are signed up to recieve emails any time a new post or reply to existing post is made. You can change this setting while logged in under your User Profile by clicking on your user name at the top right of any page, next to the Date (or by clicking on the My Profile Button on any Forum Page). Once you get here, click on the "Edit Profile" link below your Quick Profile Information. Finally, select "Manage Profile" and scroll down the the very bottom to change your forum email subscription Settings. 

 2)  Each Entry must have an assigned Category and EntryType.  Not all categories have subcategories, but if the category you pick has subcategories, please pick the most appropriate for your entry.

 3)  Only registered, logged-in users have the privledges to create posts, reply to posts, and view attachments of posts.  Registration is free, and like any other forum, is our way of increasing forum functionality and security.

 4)  As a registered user, you will also have the ability to subscribe to threads individually, rate them, and view a list of your posts.  You can also edit posts that you have made.  Also, as a registered user at Revitinfo, you automatically are signed up to recieve emails any time a new post or reply to existing post is made. You can change this setting while logged in uder your User Profile by clicking on your user name at the top right of any page, next to the Date. Once you get here, click on the "Edit Profile" button below your Quick Profile Information. Finally, select "Manage Profile to change your profile Settings.

 5)  Soon, there will be a way for users to request other categories/SubCategories via a request form.  Currently, for our system to work the way it has been designed, the category and subcategories as well as EntryTypes must remain a standard for all users of the site, in order to make searching/browsing information faster and easier.

 

Copyright Notice:  Autodesk: Revit is a product that is wholly owned by Autodesk. Any reference to Revit, Revit Architecture, Revit MEP or Revit Structure on this site is made acknowledging this ownership. Refer to Autodesk's own web site and product pages for specific trademark and copyright information. Autodesk represents a great many products and every attempt will be made to respect their ownership whenever one of these other products is mentioned on this site.

MiddleR
BottomL BottomM BottomR