×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

import CAD into Excel
4

import CAD into Excel

import CAD into Excel

(OP)
Does anyone know  a way to import cad drawings into excel

RE: import CAD into Excel

Export them as images, paste them in.
Updates are not automatic, of course.

 

Mike Halloran
Pembroke Pines, FL, USA

RE: import CAD into Excel

(OP)
nothing happened.   what am i doing wrong?

RE: import CAD into Excel

From AutoCad, select all of the entities that you want exported. Then from the File menu, export a wmf file.

From Excel, Insert Picture.

RE: import CAD into Excel

set your background to white in ACAD, and then do your copy/paste image in Excel if you don't like the black background in the Excel image.

RE: import CAD into Excel

Well, for one thing, you're not giving us many clues with which to help you.

What cad package are you exporting from?

What kind of file are you exporting to?

 

Mike Halloran
Pembroke Pines, FL, USA

RE: import CAD into Excel

I did this a few months ago..

From AutoCAD, select what you want to copy. Make sure you are zoomed in, as when you copy, it somehow is reflected in the copy..

I simply pressed CTRL+C, opened "paint" and pressed CTRL+V. If you have a black background in AutoCAD, paint allows you to invert colors. Once you get it zoomed to the size you want, save it as a bmp., then simply import it into Excel from the "Insert-From File" option within Excel (or something like that)

 

RE: import CAD into Excel

(OP)
Thanks Steve .... It works like a charm

J

RE: import CAD into Excel

We use print screen to import ANY graphic into Excel.  It's control alt prnscrn.   A duplicate screen comes up on the montitor and we just select the part of the screen we want and then click in Excel and then ctr V.  Works like a charm and you can then do any additional formatting.

If you are using ACAD, then make sure your background color is white.

You can also paste into Word, InDesign, and Photoshop.

RE: import CAD into Excel

(OP)
Thanks OLDRUNNER

When I Choose control Alt PrtScn  no duplicate comes up.  And when I go to Excel (or Word) and press Ctrl +V.  Everthing that was on the monitor is pasted.

The same thing happens if I start with PrtScrn ( ie with no Alt.)
I use Cad 2004 ...would that be the difference?

 Sincerly
J  
PS I'm an olrunner too lol, would that be my problem?  lol

RE: import CAD into Excel

The Snipping Tool (included in Windows since at least Vista, not sure about XP) has a couple of advantages over the Prnt Scrn method:

- You select the area you want to copy, so you can paste straight into the destination package.

- You can save the clip as a jpg, gif, png, or mht (single file HTML), rather than a very bulky bmp.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: import CAD into Excel

If your version of windows doesn't include a "Snipper" tool you can get a free one at the link posted. It's a handy little tool. After you take a snapshot of the area you want to import to Excel, open "Paint", Ctrl V, and save as what you wish. Not sure which version of cad you're using but you could also print to a pdf. Use the "Window" option in the cad print dialog and choose the area you want to print. Then import to Excel.

RE: import CAD into Excel

PS. It's ScreenHunter 5.1 Free

RE: import CAD into Excel

The available native tools in XP and forebears are Ctl-PrtScr and Alt-PrtScr.  One captures the entire desktop.  One captures the top window ... with the borders, title bar and all that crap.

So I paste it into Paint, and copy just the part I want.

... which if faint memory serves, comes in with an undesirable insertion point that causes odd behaviors in Excel, so I go to the trouble of clearing Paint's field, shrinking the field, and pasting the clipboard so the insertion point is at the u/l corner of the image.  I usually save that image as a .bmp file for fun, copy once more, and _then_ paste.  The .bmp file allows me to open and edit the image later.

 

Mike Halloran
Pembroke Pines, FL, USA

RE: import CAD into Excel

On a multi-display configuration, <CTRL><ALT>PrntScrn will copy the window that has the focus.  I use IrfanView for any post-snapshot editing.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: import CAD into Excel

I do mine in a somewhat lengthy way.  I print them to PDF.  From Adobe Acrobat, I export the PDF file to a jpeg or tiff file.  In Exel, I insert the image from file.  Hope this works for you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources