02manchestera Posted December 14, 2012 Share Posted December 14, 2012 He all Im very new to autocad and i am using 2013 student there is two things i need help with. 1) I have drawen a curved line for a Directional Drill Shot and need to create a points on it every 2 metres to give a Cord postion, 2)I need to beable to transfer these points into a excel spread sheet. Many thanks Alex Quote Link to comment Share on other sites More sharing options...
aaryan Posted December 14, 2012 Share Posted December 14, 2012 Hi, You can use "measure" command to draw points on line at equal interval. Command: measure Select object to measure: Specify length of segment or [block]: 2 Secondly, search this forum you will find some of the autolisp code to export points from autocad to excel or txt. I hope this is what u need. Regards Aaryan Quote Link to comment Share on other sites More sharing options...
02manchestera Posted December 14, 2012 Author Share Posted December 14, 2012 Thanks you for your help you have helped me with my first problem many thanks but i have just had a look about and ended up at a website but im not sure what program i would need to use you option would be great http://www.lee-mac.com/programs.html Many thanks Alex Managed to find the program i want now and managed to get some points into text files but going back to my 1st question. So i have create points what look like crosshairs but as i have over 100 with every drill shot it will take forever to single select each one to export is there away to select them all quickly without selecting everything else on the drawing Many thanks alex Quote Link to comment Share on other sites More sharing options...
aaryan Posted December 14, 2012 Share Posted December 14, 2012 Try this code. This should help you out. (defun C:test (/ ss fil opn ctr prop pnt X Y Z) (setq ss (ssget '((0 . "POINT")))) (setq fil (getfiled "Save File as" "*.*" "csv" 1) opn (open fil "w")) (setq ctr 0) (repeat (sslength ss) (setq prop (entget (ssname ss ctr)) pnt (cdr (assoc 10 prop)) X (rtos (car pnt)) Y (rtos (cadr pnt)) Z (rtos (caddr pnt))) (write-line (strcat X "," Y "," Z) opn) (setq ctr (1+ ctr))) (close opn) (princ) ) Copy and paste this code to notepad file and save it as "Test.lsp". Dont forget to put "*.lsp" extension. Now come to autocad and type "appload" ont the command line, navigate to "Test.lsp" wherever you have saved, select the file and press load and then close the dialog box. Type "test" at the command line and select objects(points) and press enter and save the file. open that file (which is in csv format) in excel. Hope it helps Quote Link to comment Share on other sites More sharing options...
ReMark Posted December 14, 2012 Share Posted December 14, 2012 You can also use the Data Extraction Wizard native to AutoCAD. Quote Link to comment Share on other sites More sharing options...
02manchestera Posted December 14, 2012 Author Share Posted December 14, 2012 Many thanks for all your help and i will most probly be back soon asking for me help Alex Quote Link to comment Share on other sites More sharing options...
aaryan Posted December 14, 2012 Share Posted December 14, 2012 You are welcome Alex Regards Quote Link to comment Share on other sites More sharing options...
aaryan Posted December 14, 2012 Share Posted December 14, 2012 You can also use the Data Extraction Wizard native to AutoCAD. Wow! Thank You Sir!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.