AutoCAD to excel

[Ajmal]

AutoCAD to excel

From AutoCAD I will click one text and after that for I will measure one length

That both things I need to excel

1.       I will click one text that things I need to come one row in excel at the same time

2.       I will measure one length that I need to come on next row

3.       This thing I will continue

Actually, this is for quantity take off from AutoCAD to excel

 

 

Please help me

 

 

 

 

Edited October 16, 2019 by Ajmal

[devitg]

Please upload both , DWG and XLS

[BIGAL]

Interesting using Google

 

Autocad to excel 36 million.

Autocad export attributes 587,000

 

devitg this may be a useful example to be saved in the downloads area.

 

For Admin have suggested before need a excel subject catergory this would save lots of duplication.

[Ajmal]

19 hours ago, devitg said:

Please upload both , DWG and XLS

MODEL.xlsx

MODEL.dwg

[devitg]

I got it, It is a must the xls be online?. or the LISP could give a XLS or a CSV , after you m end  pick .

 

Edited October 17, 2019 by devitg

[Ajmal]

On 17/10/2019 at 19:38, devitg said:

I got it, It is a must the xlsbe online?. or the LISP could give a XLS or a CSV , after you m end  pick .

 

if you can make active excel that will okey. 2 types of data same comment..

[BIGAL]

Here is a simple answer uses pick point for distance and a csv file which you can open in excel. 

 

Change D:\acadtemp to a directory where you want the csv file to go to.

 

(defun c:ajmal ( / fo txt pt1 pt2)
(setq fo (open (setq fname "D:\\acadtemp\\ajmal.csv") "w"))
(write-line "Size,Length" fo)
(while (setq tent (entsel "Pick text"))
(setq txt (cdr (assoc 1 (entget (car tent)))))
(setq pt1 (getpoint "Pick 1st point for length"))
(setq pt2 (getpoint "Pick 2nd point for length"))
(write-line (strcat txt "," (rtos (distance pt1 pt2) 2 0)) fo)
)
(close fo)
)

 

[Ajmal]

I need this quantity at the same time in active excel 

[BIGAL]

Ah yes the answer is the $100 question, only joking, its not straight forward but it is achievable and again there are just so many answers to your question out there  that do just that pick something in Autocad and put an answer in a Excel cell.

 

This is why the csv is offered first as its simple. 

 

The excel answers always seem to come back with more requests for enhancements people like me offer solutions for free here, so Cadtutor should not be used as a I want for free. Start with getexcel.lsp.

 

Again GOOGLE search here also, it may take say an hour but you will find what you want it is definitely out there.