Using CAD and Excel together
Using CAD and Excel together
(OP)
I have heard that, one can compile on EXCEL a set of 3D coordinates and plot them directly on CAD (rather than manual entry on CAD one by one). How is done? Someone Please send me a link or tutorial on the same.
Am working on a project and the first assignment is to create a model. I have a whole set of coordinates for the model but the monotony of plotting is rather getting cumbersome.
Am working on a project and the first assignment is to create a model. I have a whole set of coordinates for the model but the monotony of plotting is rather getting cumbersome.





RE: Using CAD and Excel together
Close .txt file.
Open .txt file in Word.
Under Tools, Options, Formatting Marks, check the All box.
The tabs are now visible as arrows.
Select an arrow, copy it.
Open Edit, Replace.
Click the cursor into the Find What box.
Hit Control V. This pastes the tab in.
Under Replace With, insert a comma (,)
Select Replace All.
Now the coordinates are in x,y,z format, which ACAD will recognize.
Remember: The Chinese ideogram for “crisis” is comprised of the characters for “danger” and “opportunity.”
-Steve
RE: Using CAD and Excel together
In a single column in Excel, combine your data in x,y,z format, using the "&" or "concatenate" function.
In AutoCAD, start the "multiple point" or "3dpolyline" command. Then copy and paste the data from Excel into the command line. AutoCAD reads the point data as command line input and draws it.
Good luck!
RE: Using CAD and Excel together
http://www.dotsoft.com/
Very easy to use. Open Excel, do your typing, open Autocad, and start XL2CA program.
Program asks where and scale to insert the spreadsheet into
autocad.
RE: Using CAD and Excel together
RE: Using CAD and Excel together
RE: Using CAD and Excel together
RE: Using CAD and Excel together
point # northing easting elevation point code
1 5000 5000 500 G
Running the lisp with this txt file will insert a point at location 5000,5000,500. The point # and point code would be plotted on a different layer and can be turned off as well as the elevation text. I would post the lisp here, but there is a block that goes with it. Post your question at www.theswamp.org I will look for it there. I would ask for an email, but the moderators here don't want email addresses posted because of attracting spammers.
RE: Using CAD and Excel together
RE: Using CAD and Excel together
I wanted to use what you are describing to create real-time pipe tables, linked to profiles.
He was adament that it is possible, but then he quit before we got to institute it.
Josh, or anyone else, if you are out there, now is the time to chime in...
Remember: The Chinese ideogram for “crisis” is comprised of the characters for “danger” and “opportunity.”
-Steve
RE: Using CAD and Excel together
http://usa.autodesk.com/getdoc/id=TS55797
Draw polylines defined by equations
http://usa.autodesk.com/getdoc/id=TS31405
RE: Using CAD and Excel together
RE: Using CAD and Excel together
This was a long time ago but hopefully the technology has only gotten better. I'll try to find it and figure out how it worked.