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.
I'm using AutoCAD 2004 and version 2000 of Excel.





RE: AutoCAD and OLE obhect from Excel
"Everybody is ignorant, only on different subjects." — Will Rogers
RE: AutoCAD and OLE obhect from Excel
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
ht
"Everybody is ignorant, only on different subjects." — Will Rogers
RE: AutoCAD and OLE obhect from Excel
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
RE: AutoCAD and OLE obhect from Excel
RE: AutoCAD and OLE obhect from Excel
RE: AutoCAD and OLE obhect from Excel