Jump to content

Measured distance to excel


Recommended Posts



hello everyone. i am new to autolisp. i need a routine that can calculate distance between two points and write it down to active cell of active workbook. (wherever selected in excel).


Is it possible? will be very helpful to me.



Link to comment
Share on other sites

Hi everyone,


Thanks BIGAL for your reply. apologies if i mentioned stupid things. Let me brief you with the problem. i work as a quantity surveyor in building projects. We mostly get autocad drawings from consultants and prepare quantities spreadsheets. I wonder if i have a routine which can directly export data from autocad to excel. It will be very productive and cuts the working time by half.


The routine should ask for options (what you want to export) i.e. distance, length, area or text. once we make a choice it will ask for appropriate selection. For example, for distance it will ask select first point then second point. In third step it may ask for "Specify column range in excel" i.e. A,B,C etc. (I assume that file name and sheet name are predefined. plz guide me on this)


On execution of command, it will find non empty cell in specified range of workbook and puts the value.


i know i won't get cake on this but bread will be fine. i also checked getexcel.lsp as you suggested. But, it lacks the functionality i need. most importantly distance measurement to excel. i am ready to learn autolisp. will be very grateful for any help to achieve my objective.


thank you



Link to comment
Share on other sites

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.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...