Jump to content
viru89

Measured distance to excel

Recommended Posts

viru89

Hi,

 

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.

 

Thanks

Share this post


Link to post
Share on other sites
BIGAL

So many, so many, so many times Autocad to excel!!! my solution GETEXCEL.lsp lots of two way routines just search for it.

Share this post


Link to post
Share on other sites
viru89

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

 

virendra

Share this post


Link to post
Share on other sites
BIGAL

Simple answer that may get you there DATAEXTRACT it has lots of filters and you can save the filters for re use.

Share this post


Link to post
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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  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...