×
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

AutoCAD and OLE obhect from Excel

AutoCAD and OLE obhect from Excel

AutoCAD and OLE obhect from Excel

(OP)
I have data on Excel sheet and I'm trying to copy it into AutoCAD drawing. I also try to do it "with intelligence", as I'm using "pastespec"-command (pastespec>paste link) when inserting the copied cell into AutoCAD. However, I can't copy all selected (copied) cells. The limit is (at the moment) 14 columns (sometimes it is 16). The amount of rows is not a problem. What can I do to copy more cells (read: columns) as I don't wanna do the copying with pieces (many separate copies).

I'm using AutoCAD 2004 and version 2000 of Excel.

RE: AutoCAD and OLE obhect from Excel

You may want to do a search on this forum about excel and pasting. It has been discussed before.

"Everybody is ignorant, only on different subjects." — Will Rogers

RE: AutoCAD and OLE obhect from Excel

Hi,
I just happened to notice we had similar questions. Pasting excel info into a drawing is a new thing to me, so I might not be giving you pertinent info, but I used "insertobj" with a link file to put a schedule into my dwg that is updated with changes to the source file. That sounds like what you mean by "intelligent" pasting. Any insight into how to control the clipping area?

sundemon

RE: AutoCAD and OLE obhect from Excel

Copied from the other thread:  In excel I "hide" columns and rows I do not want to see in autocad.  In excel I highlight what I want, right-click copy or edit / copy then go to autocad and edit / paste.  If I ever want to change the cells, I right click the mini-worksheet in autocad, choose OLE and open.  When I am done in excel, I quit excel and the object in autocad has changed.

What this does is to imbed a spreadsheet into Autocad that is not linked to any other file or worksheet.  It is still an excel object, with live formulas and so can be opened and changed.

borgunit's link does illustrate the built-in limits for autocad working with excel, without third-party software.

RE: AutoCAD and OLE obhect from Excel

Can the pasted cells be plotted with the drawing somehow?

RE: AutoCAD and OLE obhect from Excel

When I do it, they plot just fine.  What is your experience?

RE: AutoCAD and OLE obhect from Excel

I have no experience plotting excell sheets I took interest in the subject because I am about to include some cells in current work and I had heard there were problems plotting OLE objects. I am glad to hear it works OK then.What release are you on?

RE: AutoCAD and OLE obhect from Excel

(OP)
Plotting is not a problem, it works fine. The only matter that "sucks" is the amount of columns. I found the cutting and pasting in many pieces to be the best way to do this. Reducing column widths and row heights cannot be done forever, as the text inside cells cannot be smaller than 8 (Arial). If I use for example font size six or seven the text is plotted in AutoCAD much smaller than it should be. That is the only problem I know about plotting.

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