Shablab Posted March 18, 2019 Share Posted March 18, 2019 I have a bunch of points with Object Data in a drawing and I need that information exported into an Excel file in the format within the Title. At the moment I have been using a workaround by importing and re-exporting and then connecting data with the Task Pane to export to excel file. Is there a lisp to better automate this process? Quote Link to comment Share on other sites More sharing options...
JuniorNogueira Posted March 18, 2019 Share Posted March 18, 2019 You can not get the result with the command DATAEXTRACTION ? Quote Link to comment Share on other sites More sharing options...
harshad Posted March 19, 2019 Share Posted March 19, 2019 try this one coor.lsp Quote Link to comment Share on other sites More sharing options...
Shablab Posted March 19, 2019 Author Share Posted March 19, 2019 On 3/18/2019 at 10:28 AM, JuniorNogueira said: You can not get the result with the command DATAEXTRACTION ? I did not know about this command and it gets me 85% there. I do not see where to export Object Data with this though. If it's an option within and I'm just missing this then it should give me everything I need. 2 hours ago, harshad said: try this one coor.lsp 8.92 kB · 1 download That Lisp seems to work well but it only exports (X, Y, Z) and doesn't give me an Object Data with the points Quote Link to comment Share on other sites More sharing options...
Roy_043 Posted March 19, 2019 Share Posted March 19, 2019 (edited) @Shablab What is meant by 'object data'? Edited March 19, 2019 by Roy_043 Quote Link to comment Share on other sites More sharing options...
Shablab Posted March 19, 2019 Author Share Posted March 19, 2019 12 minutes ago, Roy_043 said: @Shablab What is meant by 'object data'? See below. FeatId, OBJECTID, ANCILLARYR, & ENABLED are all associated within Autocad as 'Object Data' (OD). They are just attributes associated with an object given to provide additional information where necessary. You can Mapexport/Mapimport the points with this Data as well. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted March 20, 2019 Share Posted March 20, 2019 Search export object data its like attributes just approached in a different way. 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.