FireACAD Posted July 26, 2017 Share Posted July 26, 2017 Hi I would like to write a list or .net for inputting dimensions on the fly into a excel spread sheet. I create fabrication sheets (spool sheets) for pipes for the fire protection industry. Which basically means I have to describe each pipe in test format, this gets very tedious and mistakes creep in. So what I would like to do is in AutoCad type in DI and start clinking from point to point ( the dimensions need to be running) each point is inserted into a new cell on the same row? Can this be done? Quote Link to comment Share on other sites More sharing options...
BIGAL Posted July 27, 2017 Share Posted July 27, 2017 1 yes 2 use (getpoint) (getpoint) for the distance hint there "distance" 3 write to excel using one of the many excel code examples out there I found Getexcel.lsp very usefull. Have to do some work now will see if later I have some time. Quote Link to comment Share on other sites More sharing options...
FireACAD Posted July 29, 2017 Author Share Posted July 29, 2017 Thank you. I will give it a go. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted July 29, 2017 Share Posted July 29, 2017 I may have time later today to have a go. Need a sample excel please post. Have a go yourself just post when you get stuck. Quote Link to comment Share on other sites More sharing options...
FireACAD Posted July 29, 2017 Author Share Posted July 29, 2017 Thank you here is what I am trying to achieve Attached DWG of a pipe represented by a line, each point on the line represents a fitting for instance a 15mm weldolet in facing down. In this example the pipe is 6200mm long, I want to input the distances into excel automatically. The attached sheet shows the format for now I just want to get the distance (highlighted in green). In the future I would like AutoCAD to prompt the user to input a value after the distance is imputed automatically. Again appreciate any input your original comments has been a great starting point. SAMPLE 1.xlsx sample 1.dwg Quote Link to comment Share on other sites More sharing options...
BIGAL Posted July 29, 2017 Share Posted July 29, 2017 Have a look at this http://www.cadtutor.net/forum/showthread.php?101313-Specific-dimension-extraction-to-Excel most of the code is there already just needs a tweak maybe tomorrow. Quote Link to comment Share on other sites More sharing options...
FireACAD Posted July 29, 2017 Author Share Posted July 29, 2017 thank you, that looks great I will plug away at it 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.