How can i copy the selected dimension from CAD to excel

[skchui6159]

As captioned top, I want to copy the dimension to excel from left to right cell. How can I do? Anyone help?

[paullimapa · Accepted solution]

Give dimtoxcl.lsp a try.

This should take all the dimensions you select in the same row and sorts them left to right and place in to row in Excel.

[vladimir_michl · Accepted solution]

You can try the freeware utility Click2XLS (its Text2XLS command) - supports all kinds of drawing texts, incl. dimensions as they are displayed.

https://www.cadforum.cz/en/export-text-from-dwg-drawings-to-excel-tip9814

Vladimir Michl, www.arkance.world  -  www.cadforum.cz

[skchui6159]

EXACTLY WHAT i WANT! THANK YOU VERY MUCH!

[skchui6159]

Thank you very much!

[paullimapa]

Glad to have helped…cheers!!!

[skchui6159]

If I need to sort x=right to left?

I find it. It should be 

(defun sortListofSublistsbyItemX (lstOfSublists intItem)
(vl-sort lstOfSublists '(lambda (X Y) (< (nth intItem X) (nth intItem Y))))
) ; sortListofSublistsbyItemX

">" change to "<" 

[paullimapa]

yep, that's it!!!