Print Page | Close Window

extracting point coordinates to excel

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=8896
Printed Date: 18.Apr.2026 at 04:24


Topic: extracting point coordinates to excel
Posted By: designengineer
Subject: extracting point coordinates to excel
Date Posted: 27.Jan.2013 at 06:03
Hello,
At work I have to do beam deflection and has to calculate the center of gravity as well . For that I have to gather information about different coordinates at various points on the skid . Right now I am using ID command and then enter that information manually in excel . 
Is there any way that I click on a point and its co-ordinate value information goes into the excel automatically ?
Thanks


Replies:
Posted By: CarlB
Date Posted: 27.Jan.2013 at 09:46
Are you trying to determine the center of gravity and moment of inertia of a structural shape? If so, you can use the MASSPROP command in AutoCAD.
 
If you really need the points in Excel, then yes it can be automated using a lisp routine. The data extraction could be coordinates of a polyline, or points you pick.  Output may be to a text or csv file, which Excel can open then parse into columns.
 
You should avoid manual entry.  At the minimum, copy and paste from the command line to lessen chance of errors.

Posted By: designengineer
Date Posted: 27.Jan.2013 at 17:59
Thanks for the reply .
Massprop is a great idea but there is slight problem , as there is an engine and compressor on the skid . They are just block and I don't think they have the actual weights shown in the model .
Another thing is that I need the COG from the datum , which is from one end of the skid .
I think lisp will work perfectly but I have to learn it .
 

Posted By: edwinprakoso
Date Posted: 28.Jan.2013 at 08:34
If you have drawn the points at those locations, you can extract their coordinates to excel using DATAEXTRACTION. However, it only extract available points in your drawing.
It will not export coordinates to excel everytime you click a point, like your original inquiry.


-------------



Edwin Prakoso

http://cad-notes.com" rel="nofollow - CAD notes | CAD tutorials and best practices

Posted By: Vladimir Michl
Date Posted: 28.Jan.2013 at 14:48
See the related tip 8030 for the Click2XLS click-and-extract utility.

-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner


Print Page | Close Window