Inserting Excel Spreadsheet into ADT 3.3
Inserting Excel Spreadsheet into ADT 3.3
(OP)
We have Architectural Desktop 3.3 and are having trouble inserting a 'whole' excel spreadsheet into our drawing. We've tried every possible way of inserting this spreadsheet including the Insert OLE and copying and pasting special. The pasting special got us the furthest with a total of 13 columns being inserted. We have 20 colunms that need to be entered and would really like to conquer this obstacle, so when we change info in the spreadsheet it will be changed in the drawing. Any suggestions?





RE: Inserting Excel Spreadsheet into ADT 3.3
RE: Inserting Excel Spreadsheet into ADT 3.3
That ended up being our solution, also. I was just hoping there was something else that could be done. Thanks!
Joanna
RE: Inserting Excel Spreadsheet into ADT 3.3
I use excel to generate lighting fixture schedules with the following: you of course can do it the same way for door/window schedules, etc.
-Copy a range of cells from excel, watch the origin of the text in Excel, use "left justified" so the text comes into ACAD the same way.
-Do a "Paste Special" into ACAD. Paste the cells as "AutoCAD Entities"
-Move/Scale the block of text to the location/size you need
-Xplode (XP) the text so you can put it into whatever layer you want (ie A-Text)
-If you have text on the drawing that is the same size/font as what you want, do a "Match properties" to give the text the font that you want.
The advantage to doing this of course, is that the text can be modified as needed as the project progresses thru the design and construction doc phases! Hope this helps.
RE: Inserting Excel Spreadsheet into ADT 3.3