AutoCAD and OLE obhect from Excel

[khytonen]

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.

 

[borgunit]

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

 

[SUNDEMON]

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

 

[borgunit]

This may help..

http://usa.autodesk.com/adsk/servlet/ps/item?id=2895807&linkID=2475323&siteID=123112

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

 

[IFRs]

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.

 

[cadastrophe]

Can the pasted cells be plotted with the drawing somehow?

 

[IFRs]

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

 

[cadastrophe]

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?

 

[khytonen]

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.